Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

1
vote
2answers
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
1answer
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
2answers
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
2answers
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
2answers
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
2answers
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
1answer
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
2answers
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
2answers
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
6answers
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
7answers
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
4answers
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
9answers
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
4answers
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
7answers
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
4answers
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
2answers
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
1answer
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
3answers
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
7answers
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
1answer
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
6answers
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
4answers
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
1answer
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
2answers
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.