The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

2
votes
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
1answer
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
1answer
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
2answers
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
0answers
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
2answers
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
2answers
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
1answer
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
0answers
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
0answers
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
2answers
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
3answers
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
1answer
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
2answers
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
1answer
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
2answers
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
0answers
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
2answers
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
1answer
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
2answers
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 ...