The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

17 views

### Excel formula needs help to create table

Trying to understand how to create a table that identifies what specific dates relate to the row and column it is in.
IE. if I have columns A, B, and C. and rows 1, 2, 3 with dates applied within ...

**0**

votes

**0**answers

9 views

### How do I stop column formulas from automatically calculating in an Excel Table?

When using a column formula for a table in a workbook with calculation set to manual, when tinkering with formulas, Excel calculates them if the column formula changes.
The automatic propagation of ...

**0**

votes

**0**answers

9 views

### Allow several inputs in a cell?

I'm currently creating a worksheet to calculate my workhours. So far I've created two drop down lists; months and years. These two decide the date and day in column A.
Here`s the problem:
I want to ...

**-1**

votes

**0**answers

11 views

### How to search a string with color code in many workbooks and copy row if true

How to search a string in many workbooks and copy row if true
Under this link I found a great tool to copy a row if true from a searies of workbooks and copy them into a new workbook.
My problem ...

**0**

votes

**0**answers

12 views

### Count non-filled rows from same column in Excel 2010

So I've got a column with a Title (which I don't want to count) and hundreds of filled rows. In the second row I want Excel to calculate the sum of the filled rows. Example:
..A..
Title
Sum
...

**0**

votes

**2**answers

26 views

### How can I select and output the first and last row of a worksheet or a filtered list?

I am new to VBA and I have no clue where to start with this.
I have two columns of data:
Team Member Time
A 1
A 2
A 3
A 4
I am only interested in ...

**0**

votes

**2**answers

31 views

### How to display only data that meets certain criteria in Excel

I have a list of names, with one column further on with numerical data within, for argument's sake like shown below:
Dave 1
Bob 2
Frank 1
Dennis 3
I would like to have another table on a ...

**0**

votes

**0**answers

22 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:
...

**1**

vote

**1**answer

23 views

### Look up a name from row in a timetable and output the column header in Excel

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:
I'd like to create ...

**3**

votes

**1**answer

34 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

27 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

18 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

84 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

25 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

34 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

15 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

16 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

10 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

20 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

33 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

38 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

80 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

62 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

32 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

36 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

33 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

16 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

21 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

30 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

18 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

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