The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

3 views

### Install older version of MS Office without removing newer version first

I'm currently running Microsoft Office 2010, but I temporarily need Excel 2007. I know I can use the Custom setup at the 2007 install process to select just Excel, and based on the Setup Help page:
...

**0**

votes

**0**answers

13 views

### Excel - Looking up a name from row in a timetable and outputting the column header

I'm making a timetable for interviews which comprise of 6 stations plus a rest.
(FYI in the timetable time is progressing downwards)
Sample of timetable with names omitted:
http://imgur.com/f6E0vso
...

**3**

votes

**1**answer

30 views

### In Excel, how would I calculate the number of Mondays between dates that excludes a list of holidays?

I'm currently using this formula:
=INT((WEEKDAY(E2-2)-E2+E3)/7).
I know how to use the NETWORKDAYS function, which allows you to a specify a list of holiday dates, but I can't figure out how to ...

**3**

votes

**1**answer

26 views

### How to remove a macro button added by customized ribbon in home tab?

I have added a macro button in an excel sheet by customize ribbon and have assigned some VBA code to it to do some particular task. The problem is that when I open any new workbook, Excel shows that ...

**0**

votes

**1**answer

16 views

### How to use conditional formatting to search a specific value in a range in ms excel?

I have values in the range K5:K333. I want the value in cell S5 be searched in the range and the corresponding cells of the range being formatted.
I am using conditional formatting's "use a formula ...

**3**

votes

**1**answer

81 views

### excel ISTEXT returns True where a formula contains the answer “”

I have a formula that returns the value "" blank.(correctly) However when testing for ISTEXT, I get the result "True" I understand "" is seen as text, however Im looking to test for actual words that ...

**2**

votes

**1**answer

22 views

### Highlight rows that don't match other sheet

I'm not sure if this is possible, but I have two spreadsheets that I need to compare in a few different ways.
Here is the scenario:
**Sheet 1**
Column O=Claim Number;
Column P=Reserve Indemnity; ...

**1**

vote

**1**answer

29 views

### Make an array formula in excel calculate only on active rows

When excel calculates formulas over a column (e.g. a lookup), it's smart enough to only calculate until the last active row, rather than also running on all the blank rows.
With array formulas, it ...

**0**

votes

**0**answers

12 views

### Excel 2010 merge rows where data in duplicated except 7 columns

I have a xls file.
I has some duplicate rows of customer names and other data that is identical.
I want to be able to find the identical rows by customerid and copy data from one row to another ...

**0**

votes

**1**answer

15 views

### How to add 2 hyperlinks in a single cell in Excel 2010?

I have an excel file that contains a list of steps that I follow at work.
I want to add hyperlinks to the emails I have received & saved on the hard drive.
Every time I try to add a hyperlink to ...

**1**

vote

**1**answer

25 views

### Transform time spans to discrete steps

I have an excel sheet of some jobs (or whatever items/action) and their start and end date.
Now for each minute of the day, I need to know how many jobs were active.
So the input looks like this:
...

**-5**

votes

**0**answers

23 views

### I want to split the data in excel [on hold]

56T-C00008
4500495765/20
4500576166/60
4500661108/10
I have data like this in Excel.
I wanted to change this data in Excel:
56T-C00008 4500495765/20 4500576166/60 4500661108/10

**1**

vote

**0**answers

24 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

8 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

14 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

30 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

36 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

27 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

77 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

61 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

31 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

25 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

49 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 ...

**57**

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

35 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

32 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

15 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

20 views

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

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

28 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

27 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

31 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

16 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

39 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 ...

**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

22 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

31 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

45 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

31 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 ...