**1**

vote

**2**answers

2k views

### Drawing a line graph in Excel with a numeric x-axis

In Microsoft Excel 2010, I'm trying to draw a line graph with three different lines. I've got the graph looking the way I want, with one exception: Excel is treating my X-axis column like text ...

**1**

vote

**1**answer

3k views

### How to get relative worksheet references when copying formulas in Excel?

I have a workbook containing two types of worksheets. One type is 12 worksheets, each referring to a month (JAN, FEB, MAR, etc.) Then I have another type of worksheets referring to employee's time ...

**1**

vote

**2**answers

11k views

### Extracting Data Between two Characters in Excel

I have the following format in Excel and I am trying to extract the data between the characters:
First Last <flastname@xxxx.com>
I need to extract the email address between < and > into ...

**1**

vote

**2**answers

9k views

### Excel Date Formula - Return the next specified day of the week

I need a formula that will always return the next specified day of the week.
For instance
IF(A1="A",RETURN NEXT FRIDAY, IF(A1="B",RETURN NEXT TUESDAY.....ETC
The reason I need this is because I ...

**1**

vote

**2**answers

4k views

### How to make a dropdown list such that… (see details)

I want to plot the stock prices of certain companies VS the S&P500. I have all the price data downloaded in my excel sheet already.
I want to create a line graph in Excel. One line is fixed and ...

**1**

vote

**1**answer

1k views

### Excel array formula for max with multiple/ variable criteria

G'day there,
I have a sheet that contains 365 rows, representing dates from a referred Start Date (for the following year). There are about 30 columns each of which has an agency name.
The cells in ...

**1**

vote

**2**answers

2k views

### Excel: Merge two tables based on one column

I have two Excel 2007 sheets A,B with the same columns.
B contains less rows, but has a column with updated data (i.e. data in this column is newer than in the same column in A). I want to take every ...

**1**

vote

**1**answer

6k views

### How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X

I have a CSV file which I can open and view the column with Chinese letters normally with TextMate.
However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. ...

**1**

vote

**2**answers

8k views

### Excel: text values in a pivot table?

I have a table (in MySQL) with 3 columns:
Location Category Supplier
A Computers Company X
A Printers Company Y
B Computers Company X
B ...

**1**

vote

**2**answers

6k views

### COUNTIFS does not seem to count blank cells

I am trying to build a COUNTIF statement in Excel 2010 using a total of 4 sets of criteria. I would ideally like it to look something like this:
COUNTIFS(range1,value in a1,range2,value in ...

**1**

vote

**2**answers

676 views

### Excel conditional formatting of row

Can someone please tell me how to highlight multiple cells in a row based on some values in any one of a given number of cells?
For example, if in Row 2 any of the cells from D2 to L2 have value "A" ...

**1**

vote

**1**answer

3k views

### How can I display only the unique values in one column in Excel?

Is there a way to display the unique values in a column ONLY?
Example:
AAPL
AAPL
AAPL
AAPL
AKAM
AMZN
AMZN
AMZN
AMZN
AMZN
AMZN
Expected result:
AAPL
AKAM
AMZN
I have already done a sort for ...

**0**

votes

**2**answers

58 views

### Searching and Inserting Data Based on Date Range

In another post, a formula was given that was meant to help search and insert an entry if the date associated with the entry was less than the date on another sheet. The formula was as follows:
=IF(
...

**0**

votes

**2**answers

36 views

### Using Index Match Conditionally to Indicate Whether

I feel pretty comfortable with INDEX MATCH, but I came across a problem I'd like to use it on where I'm not quite sure it works. I have two sheets: the first smaller sheet has a small subset of ...

**0**

votes

**3**answers

267 views

### Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green ...

**0**

votes

**1**answer

55 views

### Clever way to connect multiple images to on-click macro - VAB Excel

I have asked this question before, but admittedly in a terrible way, so I am asking this again. So here I am once more.
I am making a program in VBA Excel - or better, combining a certain worksheet ...

**0**

votes

**1**answer

61 views

### Excel count all rows that contain certain values for certain fields

I have a sheet with a couple hundred rows. Each row has an 'owner' and a pass/fail field. I am making a second sheet that has statistics for the users. So for each user it will count the number of ...

**0**

votes

**1**answer

124 views

### Indirect function for worksheet names in Excel?

I am wondering if there is an equivalent to the indirect function for worksheets or workbooks instead of cells. What I mean by that is I am updating a rather large and unwieldy workbook for payroll ...

**0**

votes

**1**answer

322 views

### How to combine values from multiple rows into a single row using module?

I'm looking to combine multiple rows into a single row based on a value in the code column.. I've noticed other questions on here similiar to my question but I cannot seem to extend the range..
Code ...

**0**

votes

**2**answers

87 views

### How can I filter data based on items in a list?

How can I filter entries containing any specific word in a list of words? For example, I have a list of road names in Singapore.
Amoy Street, Singapore
Ann Siang Hill
Anson Road
Arab Street
Armenian ...

**0**

votes

**1**answer

110 views

### Associate a file type to a specific Excel workbook

I have a special extension (.dia) for storing electricity diagrams. Inside these files are binary, created by an Excel library (.xlam). For fast viewing of a diagram, I would like to bind the .dia ...

**0**

votes

**1**answer

3k views

### MS Excel: Unique random number generator within a range

I searched for a similar question but couldn't find one..
I want to generate 10 groups out of numbers ranging from 1-60 (including both), with each and every group containing random and non-repeating ...

**0**

votes

**1**answer

77 views

### Excel gives error whenever I paste a code with “,”

My excel is refusing every code that I paste that has "," (comma) (like to separate arguments). What could be the cause, could it be because my PC region is Brazil and excel is in english? It seems to ...

**0**

votes

**1**answer

2k views

### How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...

**0**

votes

**2**answers

623 views

### Excel: Check if column A has any values from Column B, and delete that value from Column A

So I have two columns in Excel with these values suppose:
Column A | Column B
---------|---------
12 | 626
241 | 129
35 | 412
412 | 88
532 | 663
626 |
723 |
88 ...

**0**

votes

**2**answers

24k views

### If an Excel row contains particular words, return that row, highlight that row, or give Y/N for that row

I have a sheet containing thousands of cells in a column. These cell contains names of different securities.
Some names of these securities contains a particular string such as "C/O".
How can I use ...

**0**

votes

**1**answer

203 views

### MS Query unresponsive after launching in Excel 2007

User is launching MS Query from within Excel 2007 querying a database and then MS Query becomes unresponsive staying minimized to the task bar. Any assistance would be appreciated, the user is able to ...

**0**

votes

**3**answers

720 views

### Excel: use formula in cell format

Is there a way to use a formula as a cell format?
AFAIK, conditional formatting allows only static format applied based on some condition. I want the format itself to be dynamic. For example, I want ...

**0**

votes

**1**answer

806 views

### How to generate Excel charts show per interval?

I have the following Mathematical function (I am not refer to programming language, just simply Math):
F(X)={ 1/4, X∈(0,1]
5/12, X∈(1,2]
9/12, X∈(2,3]
11/12, X∈(3,4]
}
I want to ...

**0**

votes

**1**answer

571 views

### Excel document can not open [duplicate]

Possible Duplicate:
I cannot open Excel file
I formatted the hard drive because I had trouble with trojan and saved my document on another hard drive but when I restored my document on the ...

**-1**

votes

**1**answer

153 views

### How to get data from separate worksheets displayed in a single separate worksheet

I am working on a spreadsheet in Microsoft excel 2010. In the spreadsheet I have 3 worksheets. These are known as:
1st
2nd
Cases
Now in the 1st and 2nd Worksheets, there is a table at the bottom ...

**-1**

votes

**1**answer

57 views

### Excel 2003 according to the values of a cell should be linked to different worksheets

I have a cell that will have different text values (because it's the choice of a dropdown) according to the chosen value, it needs to be linked to a different worksheet that will preferably have the ...

**-2**

votes

**1**answer

480 views

### How to add a month to an Excel date value? [duplicate]

I tried to google for a while but it seems to have no straight forward way to do this math.
For example, we have the date at B2 12/31/2012 and need to add 2 months to it and store value in B4. What ...

**-4**

votes

**1**answer

23 views

### Formula for moving data up in excel

Can anyone help me with a funciton in excel. I have a customer that has their data all in one column. I need a funciton so that its over multiple columns on one line.
Example Below:
Column A
77.12 ...

**30**

votes

**6**answers

173k views

### How do you auto resize cells in Excel?

I have copied some data into Excel 2010. I have found that some of the cells need to be widened to allow the data to fit. How do I automatically adjust the height of the cells to fit the content?

**19**

votes

**7**answers

38k views

### Easiest way to open CSV with commas in Excel

CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this:
It's probably because when Excel thinks "comma-separated values", ...

**46**

votes

**4**answers

33k views

### How can I stop Excel from eating my delicious CSV files and excreting useless data?

I have a database which tracks sales of widgets by serial number. Users enter purchaser data and quantity, and scan each widget into a custom client program. They then finalize the order. This all ...

**36**

votes

**9**answers

111k views

### How can I “group by” and sum a column in excel?

I'm trying to figure out how to "group by" values in an Excel spreadsheet.
Given the following example (this is an inventory sheet I use at my restaurant:)
At the far right of the spreadsheet ...

**17**

votes

**4**answers

84k views

### How to set character encoding when opening Excel

Is it possible to set the default encoding for Excel (any version, e.g. 2010) when opening files like csv files (like you can in Open Office Calc)?
I When I try to open a csv file encoded in Japanese ...

**27**

votes

**7**answers

67k views

### How do you force excel to quote all columns of a CSV file?

Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?

**8**

votes

**4**answers

21k views

### Select each nth row in Excel

I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new ...

**4**

votes

**2**answers

2k views

### Excel Conditional Formatting Multiple Data Bars and Data Icons in one cell

I am using Excel 2007 on a windows machine.
I am attempting to place one data bar and one data icon into a cell under the conditional formatting. The issue is that I don't really want to have data ...

**3**

votes

**1**answer

164 views

### Randomize table guests in Excel

I have a list of people:
Column A:
person A,
person A guest,
person B,
person C,
person C guest,
...
Column B:
1,
1,
2,
3,
3,
...
So in column A ...

**30**

votes

**3**answers

172k views

### Comparing two strings in Excel?

I need to compare two strings
in excel and determine if they
are equal, the strings are in adjacent
cells. For example, given:
apple apple
water water
pear carrot
apple water
dog dog
...

**17**

votes

**7**answers

77k views

### How do I get the day name into a cell in Excel?

Given a date, how do I get the day of the week (e.g. "Monday") into a cell in Excel?

**12**

votes

**1**answer

17k views

### Saving a file in a CSV type in Excel always removes the BOM

I've been trying to find a reasonable solution/explanation (unsuccessfully) to find out why Excel defaults to removing the BOM when saving a file to the CSV type.
Please forgive me if you find this a ...

**11**

votes

**6**answers

28k views

### Excel: keyboard shortcut to move (swap) column left or right?

Is there a way to move a column (or row) to the left using only the keyboard?
I known I can use ctrl-space (shift-space) to select a column (row), but how to move it to the left or right, actually ...

**8**

votes

**4**answers

1k views

### Show cell selection in Excel when not in focus

It's really annoying that Excel (2003 and 2007) doesn't show what cell, row
or column that is selected when the window is not in focus. I typically want to
refer to the current cell or row while ...

**8**

votes

**1**answer

16k views

### Hyperlink font in Excel always changes to the default font face/size

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).
How can you configure Excel to use the same ...

**4**

votes

**2**answers

3k views

### How can I alternate grid background color in excel when a value of a single column changes?

How can I alternate grid background color in excel when a value of a single column changes?
Such as this:
I would want to do this with conditional formatting, but I can't figure out how to.