Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

1
vote
1answer
28 views

How do I break up a number in a single cell that doesnt have commas and put it into multiple rows?

So here is what I am looking to do. I have a spreadsheet with a cell that has a string of numbers in it (some are longer than others) I need to extract every eight numbers and put them into single ...
-1
votes
1answer
16 views

Array formulas and Logic, checking against multiple criteria

I'm currently just troubleshooting a report spreadsheet I've written. The logic I had written isn't working, so I thought I'd see if I could ask for some help here. Essentially, I have a list of ...
1
vote
1answer
16 views

Excel: Conditional formatting not filling in cells if adjacent cell is filled

I am trying to fill a pair of cells in if both are blank. Which works unless the cell next to the pair is filled in. How do I go about resolving this issue? Formula: =AND(ISBLANK(F2),ISBLANK(G2)) ...
1
vote
1answer
18 views

Excel (Custom Format): Format numbers to be displayed with a + as a thousand mark

I don't know how to explain this in simple words, so I will give you some examples. I have some numbers and I want a custom format to display them like this: 0 to be 000+000 12 to be ...
0
votes
0answers
24 views

Average If function not returning correct value

I am trying to do an average if function, it is the average of some cells which provide a number based on a formula in that cell subtracting dates in other cells giving a number representing a span of ...
1
vote
1answer
40 views

How can I add a fixed amount of time to all “hh:mm” strings in a document?

I have a document that's a transcription of a video interview. The video itself has embedded SMPTE timecode as well as burnt-in timecode (BITC). The SMPTE timecode and BITC correspond to the time of ...
1
vote
2answers
25 views

Excel - plot rate of occurrence of certain event

I'm analyzing logs where I have the times where a certain event occurs, example: t=1.05s t=2.25s t=2.26s t=2.35s t=3.40s I want to be able to plot the rate of occurrences/second in order to see how ...
1
vote
1answer
15 views

Calculating progressive monthly averages

This might end up being super simple, but I can't seem to put my finger on it. What I'm attempting to do is having a 'rolling' average for the month. So, if we are on week 2 of the month, it will ...
-1
votes
1answer
17 views

Excel Macro to Find Cells that Contain “<6” in Columns with Header “n” and Replace the Adjacent Cell with “S”

I'm relatively new to Excel VBA programming and I'm having problems generating a macro. My data looks something like this. In column A titled "N" I have counts going down several rows. If a count was ...
1
vote
0answers
15 views

Excel 2013 Workbook Size Optimizer not working

I have a large PowerPivot/PowerView workbook that needs to be cleaned up. Microsoft offers a free tool called the Workbook Size Optimizer for situations like this, but I have not been successful in ...
1
vote
1answer
35 views

How to make a concentric pie chart in Excel?

I'd like to make a chart (preferably on its own sheet) that is a combination of a regular pie and a doughnut. The regular pie sits in the middle and the doughnut surrounds it. I have seen those ...
0
votes
1answer
15 views

Forcing axis units in Excel 2013 plots, being written after minimum bound of axis

I have a plot, drawn in Excel 2013. The data begins from almost 0.9 to almost 5.1. I want the x axis to be written from 1 to 5 and to show the data from 0.9 to 5.1. Upon my best effort, I could set ...
0
votes
3answers
25 views

Excel multi table lookup, can you find a more elegant solution?

This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...
1
vote
2answers
15 views

Excel - copying links without forumla

I have a column of hyperlinks in an excel file. I've used formula: "=HYPERLINK(A2,A2)" and it gives me a hyperlink to a file on drive. In column A there are text versions of alll of the links - ...
0
votes
1answer
30 views

Count instances of letter or number in a single cell

I would like to count instances of numbers from a number in a cell. For expample we have the number 78812557839. I need a formula or function to count how many instances of 7,8,1,2,5,3,9 this long ...
1
vote
0answers
23 views

Combining INDIRECT() and UDF [on hold]

I have created an Excel UDF to find the nth occurrence of a value in a range. The UDF is based on the one at http://www.ozgrid.com/Excel/find-nth.htm: Function Nth_Occurrence(range_look As Range, ...
-4
votes
0answers
24 views

I want to create a graph with two functions that allows me to input variables and see the result [on hold]

I want to measure the savings of buying an energy efficient bulb. To do this, I want to create a graph that allows me to input the variables and then the results are displayed. There are two ...
1
vote
2answers
29 views

Count number of selected cells

How do I count the number of selected cells, regardless of cell content?. There are two use cases. I need use case 2 right now: When I make one or multiple selections, I want to know how many ...
1
vote
2answers
34 views

Excel Spreadsheet sheet formulas

I would like to be able to have a cell in a 2nd tab equal what was in a previous tab, then create a new tab, copy and paste and have the spreadsheet formula update to the previous tab instead of ...
1
vote
2answers
22 views

Concatenate cells but exclude empties in Excel

I am wondering how I can concatenate a row of cells with comma separated values but exclude empty cells. For Example the list would be: A1 - Dog B1 - "empty cell" C1 - Cat I am looking for a ...
0
votes
0answers
28 views

Excel: Find duplicates among 2 colums

Giving an excel file with 2 columns: A: 5000 numbers (some repeated) B: 525 unique numbers I want to know if for each number in A there is a instance of that number in B. Meaning: for A1, is ...
0
votes
1answer
17 views

Combining the ISBLANK and Date function

I have been searching through forums and can not figure out how to succesfully combine the two functions ISBLANK and a date function. What I need to do is use this formula in google sheets for ...
0
votes
1answer
23 views

How to find trendline without graphing

I have set of data in Excel for which I would like to find the trendline. Is there a way to find the trendline (linear and non-linear) from the raw data? Or do I have to graph the data and use the ...
1
vote
1answer
22 views

Remove duplicate rows, and keep newest row based on date column

I have a huge list of data in excel (250.000+ rows) in the following format: Number Value1 Date Value2 40325 1 21/01/11 18.10 2 65485 3 22/01/11 16.47 2 40325 9 ...
2
votes
1answer
19 views

Convert multiple unicode values to corresponding text in Excel spreadsheet

If my Unicode character contains more than one hex value in an Excel cell, how do I write a function in Excel to convert it into the corresponding character? For example: Unicode Hex values in Excel ...
0
votes
2answers
48 views

Excel - Manipulating data in awkward format

I have a dataset that I want to analyse, but it is in quite a strange format. See below: > Account_Details Account_Name > account # 1 client name > product 1 name ...
2
votes
2answers
29 views

Hide data label containing series name if value is zero

I have made a chart in excel in which I would like to hide the data label if value is zero. For data labels that contain the value itself this is done by using custom formating as explained here How ...
0
votes
1answer
25 views

In excel, I want the word “Name” to display but not print

I have a census sheet in excel that has to list peoples name in a specified area. There are a set number of rooms that can contain people, but they are not all full at all times. I would like to have ...
1
vote
1answer
27 views

How do you create a conditional nesting formula on excel 2010 with more than 3 conditions?

I have "A, B, C and D." I need " if a>0, use a, otherwise, use b. If b has the error "#N/A", use c, otherwise use b. If c=0, use d/61, otherwise use c. So far, I have this: ...
1
vote
1answer
13 views

Cell references in formulas keep moving with old data in Excel

When I update Excel to the latest figures my formulas keep moving with the old data. I have already tried using absolute and or relative references like $A$1, $A1, A$1, and A1. I've also tried using ...
0
votes
1answer
15 views

I have an Excel file with a worksheet that is completely white and on interactive. It's also not protected. How do I acces it?

I am working on a rather complex Excel file that has various Database connections and VBA code behind it. This file is getting pretty old and has had many people work on it during its life. There is ...
0
votes
1answer
10 views

Excel Mac (Office 11): Sum cells within a row that meet heading criteria

I am trying to create a formula that will sum cells in a row for those cells with column headings (number 1 to...n) that fall within a range, say 2 to 4 or 3 to 9. The critera for the column ...
0
votes
2answers
21 views

Is there a way in Excel to have a formula stretch its row extent to include adjacent inserted rows?

In Microsoft Excel 2011 for Mac OS X, I have several columns of numerical figures and a final row at the bottom that shows a maximum value for each column. My data set is ordered, such that most ...
-2
votes
1answer
63 views

Determine if a financial year has a leap day in it in Excel

Our financial year runs from the first of March to the last day of February. I need a formula in Excel that tells me if the financial year has a leap day (the 29th of February) or not. For example ...
0
votes
0answers
22 views

Excel 2010 Macro throws Object or Method Not Supported error

I keep getting an error 438: Object doesn't support this property or method when trying to run a portion of a macro I have that updates three PivotCharts off of the top three items on another table. ...
0
votes
3answers
26 views

Filter only rows with 0 value in multiple columns

I am trying to filter rows only if they contain 0 in multiple columns - I want to delete the rows. eg only rows where value is 0 in all columns E,F,G,H
1
vote
1answer
23 views

How to create stacked chart

I go nuts at Excel. So here's my problem: I have a table where the Y-values are projects that we are working on in that year on the x-values are project related properties. On of those properties is ...
1
vote
2answers
133 views

How to get Ctrl+Shift combination for Excel macro shortcut?

When I click "Record Macro", the record macro window only shows Ctrl + another key as the shortcut key. As we all know, most of the Ctrl+ are used by Windows and Excel for other important functions ...
-2
votes
0answers
15 views

Excel Function - Convert unicode to ascii [on hold]

I'm trying to figure out if there is any function in excel (2010) which helps decoding the text unicode to ascii? I have one column in my sheet which contains word/sentences in Portuguese For ...
1
vote
1answer
25 views

Excel to show icon

I want to have icons that will signify increase, decrease or equal from the prior cell. For example below in C2, the icon should increase when compared to B2 (because its value is greater). The ...
2
votes
1answer
16 views

How to hide page break lines in Page Layout view in Excel

I have a work sheet which I need to look at in the Page Layout View, however, in that view the page breaks show as dotted lines along the outer border. I have read this question, and the answer works ...
2
votes
0answers
58 views

Excel 2010 scrollbar goes too far

My problem is illustrated in the PrintScreen below: I've searched a lot on the Internet and almost all sources say to delete the empty rows at the end of the sheet and save the document. For ...
0
votes
1answer
26 views

Apply Names in Excel is bugged?

I see people had this problem 10 year ago and it's still not fixed. Or maybe I just don't know how to use this feature. In my sheet I have these named ranges: A1 - "name1" B1 - "name2" C1 - "name3" ...
3
votes
2answers
26 views

How to format text between branches excel using a macro Excel 2010

I found a little macro to change all the text between "[" and "]" red in excel. But i can't get it to work in Excel 2010, i get some errors. Can someone help me debug this? At the end i wish that in ...
-1
votes
2answers
14 views

Is there a way in which to show two values per pie slice in a pie chart?

Trying to show for each major slice of a pie chart(4 total slices), two pieces of data per pie slice (% of items with information and % of items without information)
0
votes
1answer
17 views

How to include image(.png) in legend of an excel chart?

All, I am trying to include company logos as legends of excel charts instead of their names automatically using VBA. Any leads will be highly appreciated.
1
vote
1answer
62 views

Excel. Looking for exact match and return value

I have 3 Excel files. Excel file 1 and Excel file 2 contains: Fixed data in column A Different values in column H. Excel file 3 (dashboard) contains the fixed data found in column A of the 2 ...
0
votes
1answer
23 views

Copy Table values from one sheet to another

On the first sheet of the spread sheet I have the following: 1 Item Item Description 2 xxxxxx yyyyyyyyyyyyyyyyy 3 4 Object 1 Object 2 Object 3 5 AAA ...
1
vote
1answer
20 views

Pivot table 'page fields' usage

In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still useful. The process starts by pressing Alt, D, P. In one of steps there is one ...
1
vote
1answer
65 views

Excel VBA row fetching loop

I have three sheets: "bom", "MPS" and "DData". What I'm trying to do is first read the value of cell A2 from "MPS" and fetch all the rows from "bom" that in column A have that value and list them to ...