A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

1
vote
1answer
15 views

Excel 2016 won't break down data for a chart

I just started MS Office 2016 Excel on my Mac, but I can't get it to create pie charts for me. Even if I choose a column of data, it seems Excel thinks it is a single piece of data. Switching between ...
0
votes
1answer
16 views

Create pivot table with one column?

I am not even sure how to title this question. If you can give me a better title I will update the question. Here is what I am trying to do: Column Title: Status A (blank)...
1
vote
0answers
10 views

Date axis with Pivot Chart (Excel 2016)

I have a list of dates across the X-axis of the form mm/dd/yyyy and have the pivot field formatted as a date. When I attempt to format the axis to be a date axis, Excel does nothing. I can literally ...
0
votes
1answer
19 views

Show middle hierarchy in Excel treemap?

I have a CSV with filesystem data; file paths and size. I've created a treemap chart from this data, but the problem is that the treemap doesn't seem to take hierarchy into account. Each data point, ...
0
votes
0answers
20 views

Excel Power User Challenge - Advanced Workbook Split [on hold]

I need to split a workbook's multiple worksheets into multiple files (not based on worksheet name). Sounds easy, but just wait. The project: It deals with very sensitive HR/performance data, and I ...
-1
votes
1answer
165 views

Excel, No longer receive the option to open files in a different format

I have a web app that saves files as .xls but are actually well formatted .html. The files have always opened with excel producing the following warning: The file you are trying to open 'file.xls', ...
2
votes
2answers
17 views

Padding zeroes in non-Text lists

I have a list of numbers that have 3 digits after the dash (FL-100), but in the list are numbers that are formatted with only 2 digits after the dash (AR-12). They all need leading zeroes in order to ...
-1
votes
0answers
9 views

Excel - Data Fill from another sheet in certain column if value is right

I want to copy certain information from a line in another sheet if in a specific column it shows a value different from Work Done. Say in column F it has a value different from Work Done, then I want ...
-1
votes
2answers
13 views

Phrase is repeated within a cell - how do I remove ONLY the second instance and keep the first?

I have a column that has a repeated phrase in it. Example: Cell A2: Weather Report. Clouds: Gray; Rain: Light; Clouds: Gray; Temperature: Hot Cell A3: Weather Report. Tuesday. Clouds: ...
-1
votes
0answers
11 views

EXCEL with macros, locked worksheets STOP WORKING

I am using Microsoft Excel 2013. When I select some columns in any of worksheets (or something like that) and right-click, then Excel stop working. Workbook properties are: contains macros locked ...
1
vote
1answer
16 views

“File in use” message doesn't appear when file is open by someone else

When Excel file is shared and someone opens it for editing, another person opening it should see a message like below: In my company we started blocking shares which have "Everyone" group added, so ...
0
votes
1answer
25 views

Excel Custom Format that separates a decimal into Years and Months

I'd like to make a custom number format that would split apart a decimal number and take everything to the left and follow that with a Y or Years and take everything to the right, multiply it by 12, ...
0
votes
2answers
41 views

Is there a spreadsheet version of .rtf?

For a text document, there's multiple format options: .doc, .docx, .odt, .rtf, etc. I use .rtf for all text documents, because its compatible with nearly everything. My question is, is there a ...
-2
votes
0answers
14 views

How to automatically transfer Excel data with no fixed cell reference to a new worksheet or workbook with specified fields

How do I AUTOMATICALLY transfer mixed data to go to specific fields in a new worksheet or workbook. All the Excel data are on separate worksheets. The columns and rows are not similar. The lables ...
-2
votes
0answers
45 views

Compare and group rows based on the sequence of their cell values in Excel 2013

I have one worksheet written to show packing contents for different products. This is how it is set up; Column A includes model numbers. Photos and part numbers are included in columns B through AH. ...
0
votes
1answer
27 views

How to change interior.color in excel, across multiple columns using a row variable

I'm trying to highlight a row that's assigned to "RowNum" I want to highlight Columns A through O. I've tried the things below, But receive syntax errors on each. sh1.Cells(RowNum, 15).Interior....
0
votes
1answer
36 views

Separating Names In Excel

I have a list of 60K names. I need to separate them into different worksheets based on their length. I have been doing it using normal way using len() formula, filter them and copy paste them to ...
0
votes
2answers
40 views

Excel Formula Shows 0 and not null

I am using VLOOKUP() to populate a few cells, but when the value does not exist in the lookup table, I want the cell to show the original content, which is usually nothing. However, when the cell has ...
0
votes
0answers
44 views

without iteration condition, =A1+C1 in C1 cell,

I've tried iteration condition, but it is not taking only the 'A1' value, if I put some value in some other cell, C1 is calculating like =A1+C1 in C1 cell,means A1 value is 5, in C1 i put this farmula ...
-2
votes
0answers
37 views

Excel - Auto Populate Break Schedule based on Weekly Schedule [on hold]

Ive been racking my brain trying to figure this out, ive searched and searched and I guess I just dont know enough about excel to be able to do this. I have 8 sheets to work with, The first one is ...
0
votes
3answers
42 views

Excel: sum values corresponding to multiple matching or individual numbers

hoping someone can help with this one: The numbers on the left (phone numbers) will be either individual or repeated. Each row has a number in the second column that is associated with that phone ...
-1
votes
0answers
17 views

Locate original install date of company wide PCs (Not on domain)

I created a program in VB using WMI to pull data from each PC in our company. After doing so, I realized that the install dates were incorrect due to Windows 10 auto-installing on most of our PCs. ...
0
votes
1answer
16 views

Ticket report - Auto populate from other worksheets into specific form

Hello ladies and gentlemen, I'm quite a dummy in excel and programming in general and I have a question related to building a report: I must present a ticket report of which tickets are opened, how ...
-1
votes
0answers
19 views

Excel 2013 Selecting multiple items all at once in a drop down

I can select multiple items individually from a drop down. What I want to do is select them all at once - something akin to holding down the Ctrl key and having each selection highlighted. Then, when ...
0
votes
2answers
25 views

Using Excel, I want to remove certain characters from spreadhseet

I have a long list of entries on a excel data sheet like: 1235. "email address", How can I remove the in bold characters i.e. 1235. " and the ", from this. The initial numbers go from 279 - 5000.
1
vote
1answer
20 views

Excel Get minimum value, and If two cells match from a row, return values from the consecutive 3 columns

Here's a simple explanation of what I'm having trouble with. Get minimum value, and If two cells match from a row, return values from the consecutive 3 columns. SUPPLIER A F4: PRICES SUPPLIER A ...
0
votes
0answers
12 views

Excel 2010: Extract worksheets from a master workbook and reference the entire sheet

I have a large list of products that are each made up of similar sets of materials. When I make the BOM in excel, most of it is the same between all models. Therefor, when a model is updated I like to ...
0
votes
2answers
53 views

Excel / Libre Office Calc: Taking the average of a multiplication

I have three rows in Libre Office Weight: 0,2 0,2 0,3 0,3 Max. Points: 2 3 4 5 Points: 2 --- 4 4 0,74 For each column that Points is divided by Max. Points and ...
0
votes
0answers
18 views

How to stop Excel “trying to connect to <my file server>” and make it just save the file?

Client: Excel 2007 on Windows 7. Server: Samba 4.1.17+dfsg-2+deb8u2 on Debian Jessie/AMD64 When opening files from a network location: Excel takes a very long time to start opening the file (...
0
votes
3answers
18 views

How do i align multiple columns in excel by name and sales?

Please ref attached image. I need to align sales for the agents in single row to match their names. The problem is that in Jan the number 1 agent may be on 5th spot and in 12th place in the third ...
-1
votes
1answer
22 views

Need to filter out some names from a list of Total names

I have a list of names. I need to separate the names which contains characters g,j,p,q,y. The names can start with G,J,P,Q,Y i.e the characters as first letter. But the characters g,j,p,q,y shouldn't ...
0
votes
1answer
19 views

How can I remove a cell from a range for a property lookup array

Lets say I have a value, A123456, in a column A, row 1, and i want to check if I have the same value in other rows of the same column, regardless of the length of the values as long as it has the same ...
-1
votes
1answer
31 views

figuring Golf Handicap

Presently we use the following formula and it works great: =IF(COUNTIF(D4:AB4,">0")<3,C4,IF((((SUM(D4:AB4)-(COUNTIF(D4:AB4,">0")*36))/COUNTIF(D4:AB4,">0")))*0.9>20,20,(((SUM(D4:AB4)-(...
1
vote
2answers
20 views

Format numbers in Excel from .9123 to 91.23 without %

I am working with Excel 2016 on a Mac, and I am trying to format grades for an assignment. I have calculated various weighted averages, and now I need to format them as "91.23" (for example) rather ...
1
vote
0answers
17 views

How to format historical dates in Excel?

I'm compiling list of historical events spanning from ancient history till current day in Excel 2016. Because I love the filtering and sorting capability of tables in Excel. The problem is that we don'...
1
vote
0answers
34 views

Excel Text Import Wizard Default Delimiter

Within the Text import Wizard, the default delimiter is TAB. Is it possible to permanently modify this default to be a comma? Don't be tempted to think that this is a duplicate question. Neither this ...
-3
votes
0answers
19 views

please help me to put a formula in this cell?

the calculation in the cell E is based on the net change in F and G. For example "when i enter an amount in the cell F3, then it should add up with the amount entered in the cell D3. and likewise when ...
0
votes
0answers
23 views

Can i modify passwordbreaker to warn for passwords created in MS office 2013 and 2016? (VBA) [on hold]

When a sheet is protected from up to version 2010 in Excel, it is possible to use the passwordbreaker macro as stated below to break the password: Dim i As Integer, j As Integer, k As Integer Dim ...
-1
votes
0answers
14 views

How do I transfer data values from a chart to a table on Excel?

I have data that is listed in a chart, for example Hello1 World2 Biscuit3 I would like to transfer this to a data table, but the numbers follow a specific pattern. For example, the table would be: ...
0
votes
0answers
13 views

Excel, Populating a cell based on what in types in another cell

I am currently working with excel and I am having a bit of difficulty. I will try to say basically what I am doing and what I would like to do. I am making a sheet that I would like to be able to ...
-1
votes
0answers
30 views

Could you help me with change in the cell

could you please help me enter a formula in the cell D3 where it changes when i enter an amount in the cell f3 and G3. im actually trying to make a inventory management sheet, where the the onhand ...
0
votes
0answers
15 views

Google Sheets: Find the most recent Time Stamp of a specific item when there are multiple entries per item [migrated]

I am trying to document the days a car was cleaned and return specific data about the cleaned car (Ie something is broken, location, etc). So, I want each car to report the most recent cleaning by ...
0
votes
1answer
23 views

Excel Combo Box — how to validate input (not data validation list)

I'm trying to use Active X Combo boxes instead of Validation Lists for some dropdown menus in Excel, because it's more apparent they are drop-down selections (arrow icon appears next to it). However ...
1
vote
1answer
32 views

Can't make the import sheets from directory function dynamic?

Can I modify the code below into a dynamic import of sheets, so I can run it in any sheet from my personal macrobook instead of a sheet called import-sheets.xls? Found the code for importing below. ...
-1
votes
0answers
33 views

Excel External Referencing Across Work Network

I've invested a large amount of my time over the past week to building a list of document types and descriptions into a series of Excel workbooks which rely heavily on external referencing (to each ...
0
votes
2answers
18 views

Using Excel VBA to find last matching row

I have a spreadsheet that includes a date and an ActionCode column. I'm using the Worksheet_Change event to run some code after the user enters an ActionCode. I'd like to have a procedure that (when ...
0
votes
1answer
32 views

Excel: How to highlight highest value cell where duplicate in another column

I have a report containing a log of members details and any actions carried out on their account. As it is a log, there are duplicate membership_numbers in column A. Column B is the action on account ...
0
votes
1answer
20 views

Open separate instances of workbooks excel 2010

I've seen a few questions of this, but most were really old. However it seems I have an interesting twist. The basic question is how to open two workbooks in two different monitors in Excel 2010. ...
-1
votes
3answers
43 views

Convert rows of Excel table into one long column

Please, can someone help me to save a couple of hours work?! I need to take the cells in a table (stored left-to-right, up-to-down), and combine them all into one long vertical column. This ...
0
votes
1answer
27 views

Replicate cell from above in blank rows in Excel

I have a data frame like this (including spaces): 1/4/2015 2 CREDT CARD SETTLEMENT 1/4/2015 3 Cash 1/4/2015 4 Cash 1/4/2015 5 Cash 1/4/2015 6 Cash 1/4/2015 7 ...