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
1answer
325 views

How to leave a blank space on IF_THEN_ELSE condition in MS Word Merge

I am running an mail merge program, where I need to merge certain fields. I have done these in the past. Just to add on these, I have to print certain text based on the value of the field in MS Excel. ...
0
votes
1answer
1k views

Launch executable from Excel 2007/2010 context menu with contents of cell as argument

For both Excel 2007 and 2010. I want to right click on an cell and have one of the choices be "Run Slump". And when the user chooses that, it will launch the executable: ...
0
votes
1answer
92 views

Is it possible to reference a set of cells the same way you reference a single cell?

I have a table 2x5 cells that I want to make available for read only purposes on multiple worksheets. Is this possible to do in Excel? I know I can give a name to a set of cells but I don't know how ...
0
votes
2answers
4k views

How can a function that expects a cell reference use it own cell's coordinates automatically?

The CELL() function allows one to construct a reference from a target cell, like: =CELL("ADDRESS", A1) will return the string $A$1. Other functions, like OFFSET() and more, expect a cell reference ...
2
votes
3answers
15k views

How to construct a cell reference from two numbers w/o using text()+indirect()?

Cell references can be constructed programmatically using a combination of the concatenate(), text() and indirect() functions with some numeric formula. This works fine, but can make the call formula ...
7
votes
7answers
9k views

Can Excel show a formula and its result simultaneously?

I know that it's possible in Excel to toggle between displaying values and displaying formulas. I'm required to turn in assignments for a statistics class as a printed Excel sheet showing both the ...
1
vote
3answers
1k views

How to easily change columns into rows in Excel?

I have a huge Excel table that I need to transform into paragraphs for a Word report, and I can't find an efficient way to do it The source looks like this: And I would ultimately need something ...
1
vote
2answers
200 views

How use vlookup in ms excel

I have an excel work book with three work sheets as bellow, above sheet contains all the sales details (i.e. Colombo(city or region)) for each month and the names of each sales persons, there is ...
0
votes
2answers
2k views

How to set the displayed precision for a complex number in Excel 2010?

MS Excel provides a set of functions to work with complex numbers. When displaying real numbers, one can set the decimal places precision from the Format Cells dialog. However, it does not work for ...
0
votes
2answers
2k views

Comparing two columns in Microsoft Excel

I'm attempting to compare two columns of data. One column (column G) is a "master" list with all account numbers in it and the other column (column A) only has a partial list of account numbers. I'm ...
0
votes
1answer
749 views

iodbctest works but Excel says “No ODBC driver installed”

I'm trying to connect Excel in OS X to a Vertica database and I have their ODBC driver working with iodbctest but when I boot Excel and click on Database I get "No ODBC driver installed" What are the ...
0
votes
1answer
286 views

Adding file name as an additional column in a .txt file?

I have multiple .txt files that I am able to combine into one big .txt file. What I'd like to do before combining is have each file name be a column inside the .txt file. The filename is a date that ...
1
vote
0answers
97 views

Why does Excel draw the upper right corner of worksheet windows incorrectly [closed]

I'm running Excel version 14.0.6112.5000 (32-bit) installed as part of Office Pro Plus 2010. Ever since I installed it, it has always rendered the upper right corner of the worksheet window ...
0
votes
1answer
322 views

Excel 2007: Need a count when comparing differences in two columns

I have one column that contains budgets and another that contains actuals. How can I get a count in a cell above the actuals column that will tell me how many of them are under their budgets? ...
2
votes
2answers
311 views

What syntax allows me to multiply numbers in Excel?

I have the following data as an example: Time per item: 0.30 min No.of items: 3 So, what syntax allows me to calculate the correct hours and minutes (hh:mm)?
0
votes
2answers
2k views

Select value from formula completion drop down list, by keyboard

How to select a value with the keyboard from a drop down list that is shown when composing a formula? I tried the following: Enter Space Alt-up or Alt-down as suggested here F4 (the default ...
0
votes
0answers
30 views

How can I do a bulk caller ID lookup (reverse phone lookup) on a list of phone numbers? [duplicate]

Possible Duplicate: What do I need to do to bulk look-up of many phone numbers? I have a tab-delimited text file with all of the phone numbers I've called or received calls from in the past ...
0
votes
1answer
142 views

VLOOKUP and match functions appear to be searching the function rather than value

Vlookup and match seem to be searching based on the function I have in my cell rather than the value i have in the cell. I have a column with dates, (ex: C2, which has the formula ...
0
votes
1answer
80 views

Merge field in Outlook based on Y/N values in Excel field

I need to a send a bunch on emails from Outlook that reads from Word and Excel. The text content will be from Word and user_email_ID, First_Name content will be from Excel. I know how to do up to this ...
0
votes
1answer
232 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
2answers
2k views

Excel INDIRECT function and conditional formatting - highlighting a row

I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...
1
vote
2answers
207 views

Set a formula on many cells with minimal manual edits

I need to set the following formula on many cells: =VLOOKUP(MAX(Historical!$A$5:$FZ$99999),Historical!$A$5:$FZ$99999,7,1) This formula looks up the most recent date in the History table, and ...
13
votes
5answers
15k views

How do I enter dates in ISO 8601 date format (YYYY-MM-DD) in Excel (and have Excel recognize that format as a date value)?

I tried to enter this date in ISO 8601 format (YYYY-MM-DD) in Excel 2010: 2012-04-08, but Excel automatically converts the date format to 4/8/2012. I tried scrolling through the different types of ...
0
votes
1answer
730 views

Searchable tags in Excel?

I'm building a database of spiders, organizing them by name, country, and region within that country. The problem is that many of the spiders exist in multiple countries and regions within that ...
1
vote
1answer
372 views

Source File not updating Destination Files in Excel

I have one source file that holds all my input costs. I then have 30 to 40 destination files (costing sheets) that use links to data in this source file for their various formulae. I was sure when I ...
0
votes
1answer
241 views

re-format date insert by “CTRL ;” in excel

In excel, we can insert date using "CTRL ;" shortcut, but the date inserted are in "M/d/yyyy" format. I want to insert date in the "d-MMM-yy" format them I've re-config the Region and language as ...
0
votes
2answers
2k views

Lookup Multiple Results for Multiple Criteria

I've got a list of parent SKUs for items I need to create in my inventory system. This list has been finely paired down to the 165 products we would like to carry. However, each one of these 165 SKUs ...
1
vote
1answer
181 views

How to retrieve all occurences of a particular value within a string?

I'm looking at an excel work-book with potential definitions for a column(upto 135) referenced from an adjacent sheet. E.g. Sheet 1: Col C (values 0-134 defined in Sheet 2 ) E.g. 0,1,8 Each row in ...
1
vote
2answers
12k views

Symbols in Excel graphs [closed]

I am a scientist and would like to use Excel to graph data. I know many people who use Excel graphing. However, Excel graphing will not let you use symbols in the Titles, in the axes labels, or in ...
1
vote
1answer
161 views

Rounding a matrix of numbers with Excel

I have a matrix of numbers in Excel consisting of numerical data. I want Excel to display each cell rounded to 5 significant figures. How would I go about this? Is it possible to perform the ...
5
votes
12answers
37k views

How to stop Excel Treating US dates as UK dates?

I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of ...
0
votes
1answer
340 views

merging duplicates and merge into rows for excel 2007

I wish to do the following but not sure how to do it...Can help on this? Original Column1 Column2 TitleA 123 TitleA 345 TitleB 888 TitleC 567 TitleC 789 After ...
2
votes
1answer
200 views

Why is Excel showing 'c' as the arg separator for fomulas?

In Excel 2007, I have a cell with "=if(true,1,0)" as the contents. If I hit the ENTER key I get an error dialog which says, "The formula you typed contains an error." The flyover help for ...
0
votes
0answers
216 views

How to apply Excel formula to datapoints for chart *without* helper column?

in Excel (2007 or newer) is there an easy way to apply any Excel formula on a set of datapoints before drawing a line/box/... on the chart, without using a helper column to do so? (This is a ...
0
votes
1answer
59 views

Excel 2007 How To Reference A Seperate Cell In WS1 From A Common Cell In WS2

I have a simple file with two worksheets in. In the first worksheet (a product list) are a number of columns, including Product Code and Product Description. In the second worksheet (dispatches in ...
1
vote
0answers
34 views

Microsoft Excel on Mac unintentionally clears my cells

When I navigate through cells using the arrow keys I have encountered some annoying behavior. If I stop at some cell for a second or so, it automatically enters edit mode for that cell clearing ...
0
votes
1answer
557 views

Sort list into multiple columns - vba

Ive got a long list of about 2000 names in column A in an excel sheet, there are only about 40 different names and they are all repeated. I need to sort them by name into columns. Some of the names ...
3
votes
7answers
19k views

Compare two Excel sheets

I have an Excel file which contains two sheets. Both contains some data. I have to find common records of the two sheets(i.e., records which are present in both sheets). I can do it manually, but is ...
24
votes
9answers
69k views

Shortcut in Word or Excel for Special Paste?

If I want to paste without any formatting, I have to go to the "Paste" button on the ribbon and click "Paste Special" and then "unformatted text". Is there a shortcut like Ctrl+V that'll ...
61
votes
11answers
120k 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", ...
2
votes
2answers
2k views

Turn Excel spreadsheet into a formula

I have an Excel spreadsheet that has a complex computation that is not trivial to turn into a macro or a single-cell formula. The spreadsheet has about 10 different inputs (values a human enters in ...
17
votes
3answers
28k views

Copy comma delimited values into two excel cells

I have comma delimited values that look like : 17 ab 2880662,2880663 15 ab 2877244,2877247 21 ab 2874201 21 ab 2873876 When I copy this to Excel it should split the comma-delimited values ...
3
votes
3answers
24k views

conditional formatting for subsequent rows or columns

I have data in a range of cells (say six columns and one hundred rows). The first four column contains data and the sixth column has a limiting value. For data in every row the limiting value is ...
1
vote
1answer
518 views

OS X Excel 2008: Export All Document Sheets to Separate Tab Delimited Files

Is it possible to bulk export multiple sheets in an Excel Document to separate tab-delimited text files? As it is, it only exports the active sheet. I've got a document with 850 sheets, all of which ...
0
votes
1answer
300 views

Internet Explorer paste to Excel hang

One of my colleagues is having a trouble when copying data from our website to Excel. Excel freezes for 5-7 minutes (we timed it) before any data shows up. If using Paste Special / Values it's ...
1
vote
1answer
129 views

Flash drive file corruption [duplicate]

Possible Duplicate: How do I recover files from an USB flash drive? I think I may have pulled my jump drive out before it had time enough to save all the information. When I tried to open ...
1
vote
3answers
3k views

On Unix, open xls file, and read the content, only the data

Does any one know how to open xls file in shell on UNIX? whether is there any tools to convert XLS to CSV?
2
votes
1answer
632 views

Split time in arbitrary periods, EXCEL

I have a list with date and quantity of items used IE: 2009.03.18 -1 2009.06.05 -2 2009.06.22 -1 2009.06.29 -2 2009.07.14 -1 2009.07.14 -1 2009.07.14 -2 2009.07.20 -2 2009.07.30 -1 ...
0
votes
1answer
1k views

How do I create a dynamic formula on Excel?

On Excel, I have a DDE formula on B1 which reads =server|info!someText.data I want to change the formula so that someText is written on A1 and then reference it on the DDE formula. Something like ...
0
votes
0answers
526 views

How do you get Excel to return an intermediate value that lies on a non-linier scatter line plot

I have data displaying the grind time for a sand sample and the resultant screen size in microns at which 80% of the mass falls through. we do this quite a lot so it will form part of a template. I ...