The 2010 version of Microsoft's spreadsheet application.

**2**

votes

**2**answers

6k views

### Copy cell reference with multiple row increment

I've exported delivery addresses from Pastel into an Excel Spreadsheet. Each address record that Pastel spat out has a lot of data for each customer that I don't need.
Given the screenshot here, I ...

**0**

votes

**1**answer

210 views

### Copying and transpose pasting from excel 2010 embedded email to other worksheet

I receive an email in the following format, from an external reporting source:
Department COUNT(*)
Contact Us 4
Customer Care Expired 1
Customer Care Premium 14
Customer Care Trial 8
In the ...

**2**

votes

**1**answer

777 views

### Connect pairs of data points in a XY scatter chart

I am trying to format the chart below, so that the area between the pairs of points is shaded. I know this is pretty easy to do with points that are not at the same x-value, but that is not the case.
...

**2**

votes

**1**answer

551 views

### Get specific value from table with table name, row and column index

I am trying to create some sort of manual filter. If you look at the image below, you can see two tables named ONE and TWO. The table to the right contains 3 dropdown lists.
The idea is that you ...

**-2**

votes

**1**answer

4k views

### Match up 2 columns in excel from one worksheet to another worksheet

I'm having trouble comparing two worksheets. I have worksheet A and worksheet B. In each worksheet, column A have the customer number and column B have the date. The same client and same date can ...

**0**

votes

**1**answer

8k views

### Auto Sequential numbering based on cell criteria

How can I create auto numbering in column A?
I need the numbering in column A to skip any rows that have the Word "TOTAL" in column C but pick right up again in the next rows.
A TOTAL
1 ...

**3**

votes

**2**answers

20k views

### Excel VLOOKUP by second column using table name as range

Using the example table below, I can use the formula =VLOOKUP("ABC123456",Table1,3,FALSE) to lookup the Demand value, but I want to do be able to perform the lookup by using the Cust Part field ...

**4**

votes

**1**answer

141 views

### 2007 Worksheet Opens with Errors in 2010

I am trying to help a customer with a specific problem that they are having with deploying an Excel 2007 Worksheet to users if they are running Excel 2010.
The spreadsheet in question has 5 to 6 ...

**3**

votes

**3**answers

5k views

### Multiplying values in Excel 2010 (Same cell)

Another excel question. I'm using Excel 2010.
If for example I have a value in cell A1, lets say 2.59
What I want to do is multiply that cell by 1.333 but in the same cell
I don't want to have to ...

**0**

votes

**1**answer

2k views

### How do I avoid #value in my excel sum equation?

When summing for the cells with nothing in them, I get #value using this formula
=CB85+CC85
Yet I don't get it when I use this equation:
=SUM(CI157:CJ157)
But on using =SUM(CI157:CJ157) I get a ...

**0**

votes

**1**answer

10k views

### VBA to insert a carriage return after existing text and paste more text

I'm adding "Measure_1" within certain cells. This requires me to double click in the cell, go to the end of the existing text, insert a carriage return (alt+ent), and then paste in MEASURE_1. ...

**0**

votes

**1**answer

9k views

### Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule

**2**

votes

**1**answer

284 views

### In Excel, how do I filter for integers, and their corresponding floats?

Let's say I have an arbitrary number of integers that I need to filter, but I also need to get the rows that show their corresponding floats as well, e.g. 10, 12, 20, 31, 42. With those, I would also ...

**7**

votes

**1**answer

369 views

### Keyboard shortcuts for selecting range using Inputbox in Excel

I am using Excel 2010 and I have a problem with using keyboard shortcuts for choosing ranges in an Inputbox.
I am using a standard Application.Inputbox with type:=8. The code prompts the user to ...

**1**

vote

**2**answers

6k views

### Extend Excel Formula Without Overwriting Background Color

In Excel 2010, how can I extend a formula down (updating cell references) and avoid overwriting the background and fonts of the cells below it?
For example, if I have the following Excel spreadsheet
...

**2**

votes

**3**answers

1k views

### Remove duplicate entries in one cell

I have data imported from a literature database (.txt format) into Excel. Unfortunately, in most cases, the authors are listed double in one cell, e.g.:
Smith, Miller, Patty, Smith, Patty, Miller
...

**1**

vote

**1**answer

568 views

### Change Excel Worksheet background colour based on values

Hopefully some one can help, but not sure if its possible. I'm using Excel 2010.
I want to change the background colour of a whole worksheet to green if the value in cell c20 is equal to or greater ...

**0**

votes

**1**answer

557 views

### Highlight field which has a passed due date in google drive spreadsheet

I calculated a due date based on Column A with EOMONTH (Column A, 3). The resulted dates are in Column B.
What I cannot achieve is to highlight the fields which are older than the current day.
In ...

**1**

vote

**2**answers

6k views

### Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010

Picture column A full of comments like feedback from a survey question. Now picture column B with a formula which counts occurrances of particular key words within each comment. I am currently using ...

**0**

votes

**0**answers

75 views

### Freeze Panes Excel 2010

How Can I maintain the freezed first top rows in an excel 2010 spread sheet
when I open the document a second time?
I already know and have tried to freeze the first couple of rows, but when I save ...

**1**

vote

**2**answers

438 views

### Excel - Formulas that total a value in multiple sheets?

I have an excel with 12 sheets named each month of a year to keep my expenses.
I want to have another sheet to have a total of a specific expenses such rent, petrol,shopping etc.
How to this so I can ...

**4**

votes

**2**answers

11k views

### How to make a chart that graphs frequency of entries?

I have an Excel workbook that has nothing but dates (sorted), in the following manner:
11/14/2011 11:53
10/14/2012 11:53
11/23/2012 19:28
12/24/2012 12:27
...
12/1/2013 11:48
I would like to create ...

**4**

votes

**1**answer

3k views

### Filter comma-delimited Excel column

I have an Excel sheet serving as a master spell list for a tabletop game. Each row (save for row 1) contains the data for a spell: Name, Target, Range, Duration, Function, Effect, Subject, Level, and ...

**0**

votes

**0**answers

41 views

### Change of cell coulor (data from another sheet)

I have 2 sheets in a workbook.
Sheet1 contains 30 columns (month wise) & 36 rows this data is numeric format.
Sheet2 has same columns & rows filled with data.
Whenever I manually enter ...

**4**

votes

**0**answers

850 views

### How can I easily split a CSV into two Excel worksheets with PowerShell? [closed]

I recently found out that PowerShell can be used to write Excel documents. The first use I thought of for this was to (at least partially) automate parsing of some CSV reports that I regularly have to ...

**0**

votes

**2**answers

41 views

### How to have a date that updates that is not today's in excel

I'm trying to make a pivot table that shows information that was updated in the last week. In the list I'm pulling from, someone manually inserts the date as necessary. I am a novice at VBA, but the ...

**2**

votes

**3**answers

104 views

### How can I avoid typing in a value which already exists in another range in Excel 2010?

I am working up a basic project tracking spreadsheet in Excel and would like to have two sheets - one which shows my active projects and one which shows my completed/cancelled/archived projects. I ...

**1**

vote

**1**answer

494 views

### How do I lookup matching values in two Excel tables?

I have two tables, each with one common index column. One table has multiple entries of the index value with other information in adjacent columns; the other table has one entry of the index value ...

**3**

votes

**2**answers

91 views

### Select only visible cells

I'm looking for a way to take a column of data (70 some rows) with some visible entries, some empty cells, and some formula results. I'm looking for a way to copy out only the entered data and formula ...

**1**

vote

**1**answer

63 views

### Excel: grab the non-N/A contents from columns

In Excel, I have two columns with formulas that produce either text or #N/A.
COLUMN_1 COLUMN_2
text1 #N/A
#N/A text2
#N/A #N/A
text3 text4
I have a third column, which ...

**3**

votes

**2**answers

4k views

### Excel: searching for a maximum lower than X

From the sorted list of values, I'm looking for a maximum that is lower than X
Example:
A B C
1 1 X=7
2 3
3 5
4 8 ANS=5
Do you have any smart ideas for this problem?

**0**

votes

**0**answers

74 views

### Excel-Using a range, how can I count specific items and show the corresponding date

I have a large table that has to remain randomly sorted. While there are many more columns of data, a simplified concept is this:
Name Position Date
1. New Hire Mgr 9/30/2013
2. New ...

**1**

vote

**2**answers

3k views

### Single cell with structured table references with Excel 2007

I need to find the Excel 2007 syntax, for getting the cell (eg. 2nd row, 3rd column), in table reference flavor.
To be clear, ref to the Microsoft - Using structured references with Excel tables page....

**0**

votes

**1**answer

361 views

### Move every first line of a pair of cells in a column to the same row to the left of the second line

How to move every first line (digits) of a pair of cells in a column to the same row to the left of the second line (names)? The pairs of cells are at a random distance in this column.
0117-000-00
...

**1**

vote

**1**answer

60 views

### Excel 2010 - apply same formatting as header cell

In Excel 2010, if I have a header row containing 200 columns, and the first cell of each column in the first row is formatted in a different way, how do I quickly copy the formatting down to other ...

**1**

vote

**2**answers

95 views

### How can I parse out the dimensions for this string in Excel?

I am trying to parse out the individual dimensions (length, height, width) for a string in Excel but am having problems determining which text formulas to use. Details below.
Data example (in one ...

**0**

votes

**1**answer

111 views

### Auto update a due date based on the last review date

I have a spreadsheet I use to maintain when certain policies are due for review. I have a column (column d) for the last reivew date and a column (column e) for the date the policy is due for review ...

**0**

votes

**1**answer

384 views

### IF statement with mail merge doesn't work

I'm trying to recreate a mail merge in the way I specified in an old question Mail merge - show line at empty cells
However, now the formula doesn't work. The structure of the documents are as ...

**-1**

votes

**1**answer

167 views

### Create an event in excel - add value to cell X after input on cell Y -> clean cell Y

Basically, what i want to do is:
Whenever i insert values in column B, it add the value to column A and then sets the column B to 0.
A B
23 0
I tried this function(passing A as uni and B as ...

**1**

vote

**1**answer

307 views

### Grouping in Excel

I have 3000 rows with 25 columns of data. I would like to group data based on the value in one column. This column has numbers (basically a bill of material). So the data is like 1 2 3 4 4 4 5 4 3 4 ...

**1**

vote

**1**answer

158 views

### Index / Match Pulling in Different than Expected Content

I am examining web stats across a range of a year. Because I want the entire workbook to be dynamic depending on what months are chosen, I have put all of several year's worth of data on one worksheet....

**1**

vote

**3**answers

2k views

### Is there a way to print multiple worksheets into one document, with correct page numbers?

I have a Workbook that contains multiple tabs that are used to list data that is printed for a report. When it is time to print the report, a user opens a switchboard and selects the desired sections ...

**4**

votes

**1**answer

8k views

### How can I get the row number from a vlookup?

So I have two spreadsheets where there is some messy data in one of them that needs to be in another.
What I have done so far is copy the columns I want from the messy spreadsheet into a new tab on ...

**1**

vote

**1**answer

1k views

### Limit number of selections in a multiselect ListBox in Excel

I have inserted the Form Control; ListBox with multiselect. But, I want to limit the number of selections to 3.
If the user tries to select more than three it should deselect the one the user tried ...

**1**

vote

**1**answer

397 views

### How can I auto import a csv to a growing list in excel?

Everyday I receive a report in a .csv format, and on a daily basis I will copy the data into an "INPUT" tab on my spread sheet. The data on this input tab keeps on growing every day with the ...

**0**

votes

**1**answer

37 views

### Transpose data by checking similar cell data

I have a Excel sheet like below..
Color Size Qty
Red L 182
Red M 223
Red S 155
Red XS 30
Blue L 700
Blue M 845
Blue S 665
Blue ...

**4**

votes

**3**answers

83k views

### Excel 2010 - how to Select or display rows if column C has specific values? No VB

I have a huge spreadsheet and column C contains IDs such as 1, 99, 732387, 28. I have a separate list of IDs such as 23, 87, 902 and I only want to display the rows whose column C value belongs to my ...

**0**

votes

**2**answers

24k views

### How can I view the properties of a button on an Excel Worksheet?

I have an Excel document that I need to modify. This thing was created by a "guru" and has been locked down from almost any form of modification.
I have the master-password to access the VBA ...

**1**

vote

**1**answer

911 views

### Excel: find indices of value in list then return largest index value from other column

I have a small Excel spreadsheet with 2 columns. One with values, the other with dates.
Eg.
A B
----------
1 1/1/11
2 1/4/12
3 3/3/13
1 12/4/12
3 2/2/11
I want to
search a ...

**7**

votes

**2**answers

44k views

### Excel Conditional Formatting if one column equal to another

This should be the simplest example of conditional formatting but I can't figure it out. I havave two columns seperated by several dozen other columns ('C'-original data, 'BO'- calculated value) and I ...