The 2010 version of Microsoft's spreadsheet application.

**1**

vote

**0**answers

22 views

### Cell with 2 options and I want to add a third

So I have this excel file where when i select a particular cell a little box with an upside down triangle appears to the right of the cell. When I click on this there is a small list of options to ...

**0**

votes

**0**answers

5 views

### Count data from one column if other column is blank

I have a table which contains data read from a database and imported into the spreadsheet. What I am attempting to do is create a "live" report that will collect this info (on refresh) and calculate a ...

**1**

vote

**1**answer

13 views

### Format Number with Leading & Trailing Zero

How can I convert 32.5 to 000003250 in Excel 2010?
I have tried TEXT(A1,"#000000.000000") and =A1&REPT("0",6-LEN(RIGHT(A1,LEN(A1)-FIND(".",A1))))
Both examples return with decimal point ...

**0**

votes

**1**answer

26 views

### How to assign a tooltip at a macro button added by customize ribbon in ms excel?

I want to assign a tooltip to a macro button added by me by customizing ribbon in options at file tab in MS Excel.
You can see this snapshot for understanding that where and how I want the tooltip.
...

**0**

votes

**0**answers

10 views

### How to color code bubble graph by numeric value?

Column E contains my Z values, and I want to use those values to correspond to a color for each of the points on the graph.
How can I do that?
The link to the file is here: ...

**1**

vote

**2**answers

25 views

### VBA Script copied from one Sheet to Another

I have a working VBA script for the worksheet Function Test Procedure(FTP) that will take the values stored in 32 individually named ranges and paste them to a separate worksheet, Results. When I ...

**0**

votes

**1**answer

26 views

### What Excel Formula will count the number of responses which match a condition but only once for that person?

I am trying to count survey responses. I would like to be able to answer how many people have ever answered the question with the answer value "1". However, people have answered the survey multiple ...

**2**

votes

**4**answers

75 views

### Native formula to check if range of non-blank cells are equal

I have three cells, any combination of which can be blank. I want to check if all non-blank cells are equal. If cells 1 and 2 have a value and cell 3 is blank, I want the formula to return TRUE if ...

**1**

vote

**2**answers

60 views

### Excel: using 2 cells to collect data from a list

My Example is this:
(workbook name"Rev)
letter weekly bi-weekly monthly
a 100 200 400
b 110 250 500
c 111 300 600
d 112 350 700
e ...

**0**

votes

**1**answer

24 views

### Connecting separated excel 2013 workbook to one

I have Office 2013 installed on Windows 7 x86. I have 4 Excel workbooks that have the same columns, and I'm thinking to connect those 4 Excel files to one "Master", so everyday these 4 Excel files ...

**0**

votes

**1**answer

23 views

### How do I keep formatting on an Excel 2010 Pivot Chart?

I have some VBA code that runs a SQL Query, dumps it into an Excel 2010 spreadsheet and refreshes the 2 Pivot Tables based off the data. I also have 2 Pivot Charts based off of the Pivot Tables, and ...

**-3**

votes

**0**answers

47 views

### Excel Spreadsheet

I am not sure how to keep a formula going when at the end of my column so that it doesn't keep pasting the same number until data is entered.
My formula is: F9=D10-E10
It is repeated for the 11 rows ...

**56**

votes

**2**answers

3k views

### Excel - can I set a cell to equal a certain value, no matter what is typed in it?

This is to play a joke on someone...not sure if it's possible to do what I want. We are circulating an Excel file among friends to select players for a golf tournament. I would like to set a cell ...

**1**

vote

**0**answers

34 views

### How can I ensure that a formula that I have written to calculate the difference between time values applies only to the filtered values?

I have two columns of data:
Member Time
A 09/24/2015 09:48:36
A 09/24/2015 09:47:40
A 09/24/2015 10:11:06
A 09/24/2015 10:08:47
B 09/24/2015 10:28:45
B ...

**0**

votes

**1**answer

25 views

### Excel - Count matching Items, comparing a row with a column

I am trying to compare the similarity of a series of sets of data...
I have a series of columns of 20 values (numbered 1-20), and corresponding rows of 20 values (also numbered 1-20).
The columns ...

**0**

votes

**1**answer

14 views

### Get date cell in excel that is at least n days older than the newest date entry

If I have a column with dates and a column with data. How do you go e.g. 10 days back in time (since the newest date entry (alwasy the last in the column)) in the date column to get the cell address ...

**0**

votes

**0**answers

23 views

### How to get last number in a column?

I have spreadsheets that contain formulas in each column. I enter a date in column"A18" and the rest of the sheet fills in across the row 18. These sheets are like sub ledgers with each sheet listed ...

**0**

votes

**0**answers

19 views

### Retrieve data from excel sheet on the basis of week and year number [on hold]

I have the following issue, I am stuck on a matter how I can retrieve and store data in a excel sheet (could be a hidden sheet) on the basis of week and year number.
Attached you can find an example ...

**0**

votes

**1**answer

25 views

### Combining multiple Excel rows based on similar contents then incrementing a column in VBA

I'm trying to set-up a VBA routine that will check all the rows of a worksheet and then combine two rows that are identical, then once it does that increment the "QTY" column.
Below is a before and ...

**0**

votes

**1**answer

22 views

### IF X and A display area “A1,G20” If X and B display area “A1,G20” but on a different sheet

I'm trying to put together a excel spread sheet for our quarries.
but we have a lot of different pits along two rivers that we collect our raw material from each with its own set of sieve results. now ...

**0**

votes

**1**answer

28 views

### How to modify these VBA codes to save excel sheet in excel format (.xlsx)?

I have added a button in excel sheet and now when I click that button it saves the sheet at specific path with specific name but in pdf format.
I want to save this sheet simply in excel format ...

**-2**

votes

**0**answers

36 views

### Reconstruct which values were in a total in Excel

I'm looking for a function in Excel to help with allocations. For example Column A will have invoice numbers and Column B will have amounts, with a total of 15 rows.
I received payment for 3 of those ...

**-1**

votes

**1**answer

14 views

### How do i use regex using instr in VBA

I am trying to use regex and kept on getting an error(compiler error) LIST SEPARATOR.Can anyone tell me which part im doing wrong.
if instr(1,regex.Pattern([A-Z]?dtest(rt,1)),b)>0 then

**-2**

votes

**1**answer

37 views

### How do I add a button to a spreadsheet and remove borders from a particular cell?

I have two queries regarding the following Excel file:
I would like a button on this excel sheet whose name should be “Save as PDF”.
When I press this button it should save the excel sheet’s ...

**-2**

votes

**0**answers

18 views

### if one cell is number, fill other column down with that number until other cell is a different number [closed]

For example: Fill column A down with the number in column C until there is a different number in column C. The number of rows after each number will vary. Thank you!

**5**

votes

**2**answers

47 views

### Can Excel perform a count-if-like sum mixing absolute and relative cell coordinates?

Suppose I have a spreadsheet structured a bit like this
_A____B____C____D____E____F_____
1 |XFoo|XBar|YFoo|ZBar|XBaz|Result
2 |8 |3 |0 |1 |100 | (*)
3 |2 |1 |1 |20 |10 | (*)
I ...

**0**

votes

**0**answers

15 views

### Excel 2010 external workbook data source select table dialog has worksheets listed twice

I have an Excel 2010 workbook with 2 worksheets (daily, monthly) where each sheet contains 1 table. I am attempting to use this file as an external data source for a Pivot Table in another Excel ...

**0**

votes

**1**answer

34 views

### How do you get the sum of the last 14 filled values in a column?

As the title say, how do you get the sum of the last 14 filled values in a column?
I can have a row of e.g. 100 posts, but only want the sum of the last 14 rows. How do you get that?

**0**

votes

**3**answers

19 views

### Consolidate data from several worksheets with same columns but different number of rows in Excel

I have an Excel workbook with several worksheets. They all have the same column names. However, the number of rows differs from sheet to sheet. I want to create an overview sheet where I can see all ...

**0**

votes

**2**answers

30 views

### Excel Formula - Budget Structured Tables - Monthly View

I've been searching around and I am struggling to find why my formulas are not working.
Before I post my formulas I need to explain what I'm trying to do and it is a bit complicated (At least, this ...

**0**

votes

**2**answers

63 views

### In Excel 2010, how can I subtract two times when I also have the date in the cell and get the value in seconds?

I have a column of data as follows:
09/22/2015 10:25:22
09/22/2015 10:27:00
I want to subtract 09/22/2015 10:27:00 from 09/22/2015 10:25:22 to get the value of 98 seconds.
I tried formatting ...

**0**

votes

**1**answer

16 views

### Excel 2010 - Stop solver when trying to find subset that adds to total

I found how to use the solver to find a subset of numbers that adds to a given total - very nice.
Now, I sometimes am not certain there is a solution. When Excel takes too long, is there a way to ...

**1**

vote

**1**answer

26 views

### Excel Charts: Is it possible to add specific text to the bars on a chart?

I have a chart which shows the daily purchases of each day in August 2015 against the daily purchases of each day in August 2015 in the bars, the lines show the total purchases in August 2014 for each ...

**0**

votes

**1**answer

23 views

### Excel - New total for every inserted amount

I'm trying to calculate a new total on the next cell in one column for every new addition to another column.
Here's an image of what I'm trying to do:
I want the Debit column to be subtracted from ...

**0**

votes

**1**answer

41 views

### How can I divide cells into two parts in Excel?

For example I want to divide cell B2 into two parts, without inserting any new row or column. Please see the screenshot below:

**3**

votes

**1**answer

41 views

### Sum values in specific rows based on whether the row has a value that belongs to a range

Here's what I'm trying to do:
I have a table that has several metrics (example: revenue, cost, etc.) for about a hundred different accounts. I can't modify this sheet because it gets auto-updated by a ...

**1**

vote

**1**answer

29 views

### How to remove space before and after any numbers?

How to remove space before and after any numbers?
for e.g. " 3,340 ".
I want this number to look like this "3,340".

**3**

votes

**2**answers

37 views

### How to use one formula in a cell

I'm forecasting multiple items monthly over ten years. There are several products that will be introduced during future months while others are simultaneously phased out. I have formulas for the ...

**0**

votes

**0**answers

11 views

### Power Pivot for Excel - version 11 not Installing on Office Professional Plus 2010

I'm trying to upgrade the Power Pivot for Excel add-on from version 10 to version 11, but I keep getting the error that Microsoft Excel 2010 must be installed first.
The laptop is running on Windows ...

**1**

vote

**1**answer

34 views

### Excel - group cells that the values together is near to a number

I have this spreadsheet:
Street 1 | 234m
street 2 | 438m
Street 3 | 759m
Street 4 | 934m
Street 6 | 126m
Street 7 | 462m
These values are summed and divided by 2 in this example, because let's say ...

**0**

votes

**2**answers

31 views

### How to align a column of cells by a symbol

I'm trying to replicate a table format from a paper,
They have centre aligned the following cells by the ± symbol. I have searched online and only found aligning by decimal.
Example input (1 column, ...

**0**

votes

**0**answers

10 views

### MS Excel 2010 Automatic calculation of formulas doesn't hold.

Once I have set formula workbook calculations to "Manual". Now I set it back to "automatic" but excel won't hold that selection after I close the file. The next time I open a file it comes set to ...

**0**

votes

**1**answer

36 views

### Format a number as a number in the header row of an excel table (not as text)

I often use cascading formulas that use the previous row's value to then return a value.
When I do this, sometimes the easiest way to set up the formula is just to put a 0 in the header row, and let ...

**1**

vote

**1**answer

18 views

### Printing cells with colored background as cells with white background

I have an Excel sheet containing several cells that have a colored background that have to be filled by the user with data.
Is there a way to print the sheet so that those cells are printed with a ...

**0**

votes

**0**answers

16 views

### File operations slow in shared Excel document located on network shared path

The Scenario: I have a number of PCs on the network, all have wired connection. All PCs are Windows 8. I have a shared Excel document which works correctly as far as Excel is concerned. I am using MS ...

**3**

votes

**2**answers

150 views

### Non-intersecting values in columns in Excel

I have three columns with values (A, B, C) as shown below. I would like a formula in column D that will return ALL the values from column B that are not listed in column A. Similarly, what formula ...

**0**

votes

**3**answers

45 views

### How do I use Excel to count the times a string appears in other sheets?

I have a worksheet that contains 10 sheets with data about facility checklists.
I am wanting to create an overview sheet that looks through all of the other sheets can counts the number of times the ...

**0**

votes

**0**answers

14 views

### How to create If a range cell in worksheet equals Y, then create new worksheets

I am trying to get my macro to copy sheets if a range value in active sheet = y, then create worksheets based on the Y values from the B Column with no duplicates. Any suggestions to what I am ...

**1**

vote

**2**answers

19 views

### MS excell =IF formula across multiple cells

I want to create an IF formula across E1, F1, G1 and H1.
If true, it should display “Commence Fire Drill,” that is situated on the data sheet C5 (E3:H3=Data!A1) and if False “All in Order” that is ...

**0**

votes

**0**answers

5 views

### How to hide different ranges (rows) with different password in the same worksheet in Excel 2010

I have two questions.
I have a tracker file (Excel 2010) and I am planning to share it with multiple users.
There are 3 sheets where all users will work (enter their respective data) however I ...