**1**

vote

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**3**answers

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

**7**answers

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

**3**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**5**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**12**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**7**answers

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

**9**answers

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

**11**answers

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

**2**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**0**answers

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 ...