**3**

votes

**1**answer

4k views

### Excel Range with IF

Is there a function that will create a range (from a range) if they match values? Essentially, I'm looking for something like COUNTIF, that will return the cells that actually match my IF.
Ideally, ...

**1**

vote

**3**answers

892 views

### How can I convert non-standard date data in Excel?

For some silly reason the data I've been provided has dates in the following format: mmddyyyy but if the date is something beginning with zero (e.g. 03132010) then it shows up without the leading ...

**1**

vote

**1**answer

11k views

### How do I get embedded Excel files to open inside Internet Explorer?

Here's my problem: I have a web application that needs to open Excel files embedded into the web page. However, Internet Explorer (9 in this case, but the same goes for 8) only gives me the option to ...

**2**

votes

**1**answer

781 views

### Disabling Autorecovery in Excel doesn't work

Start Excel 2007
Excel Options | Save | check the box "Disable AutoRecover for this workbook only". uncheck "Save AutoRecover information every ..."
Save the workbook to disk
Kill the Excel process
...

**1**

vote

**1**answer

497 views

### Show a different picture for a different value

For an excel cell, I would like to show Image1 if A1 = 1 and show Image2 if A1 = 2. Is there a way of doing that?

**2**

votes

**2**answers

716 views

### Printing a dynamic sheet as one document

I have a spreadsheet structured as follows:
Summary section at the top
Detail section on the bottom
Summary section summarizes the detail section which is filtered using auto filters
There are ten ...

**1**

vote

**2**answers

225 views

### Seeking a formula to determine duplicate numbers in a spreadsheet row?

Is there a formula to let me count if there are duplicates showing up in a row?
If I have 3 to 6 columns of individual numbers, I'd like to know if any numbers are duplicated in any particular row?
...

**5**

votes

**3**answers

9k views

### Use a Trendline Formula to Get Values for Any Given X with Excel

Is there an easy way to apply the trend line formula from a chart to any given X value in Excel?
For example, I want to get the Y value for a given X = $2,006.00. I've already taken the formula and ...

**2**

votes

**5**answers

8k views

### How can I get Excel 2011 to stop opening my Personal Macro Workbook?

Ever since I created a couple of macros in Excel for Mac 2011, the Personal Macro Workbook opens every time I open Excel. How do I keep that from happening?
I have since deleted the macros, but I ...

**3**

votes

**1**answer

415 views

### Excel: How do I get a dynamic formula which can display a total of unique values in a range?

Example range:
A10=100,
A11=105,
A12=100,
A13=100,
A14=7,
A15=105.
The formula I need would display "3" only as there are only 3 unique values in this set. The spreadsheet will be updated ...

**5**

votes

**2**answers

15k views

### How can I make Excel fetch data from a database automatically when I open the spreadsheet?

I want to have an excel spreadsheet, that when it opens will automatically populate from a SQL database, using specific queries. Each Workbook would use a different query (or multiple queries). ...

**9**

votes

**3**answers

23k views

### Excel function that evaluates a string as if it were a formula?

Suppose I have a text string like "11+5" or even "=11+5" stored in a cell. Is there a function in Excel that will allow me to actually evaluate that string as if it were a formula?
This would be ...

**3**

votes

**1**answer

1k views

### Comparing two ranges of numbers and say if the first overlaps the second

I'm new to Excel and I need to use it for a scientific paper.
I'm trying to optimize my database data gathering workflow.
My file ...

**30**

votes

**4**answers

10k views

### How do Microsoft Word and Excel run without any installation?

I was having a discussion on bookmarks in Word with a friend, and he suggested me to check out his implementation of a query in Word. Since I did not have Microsoft Word installed, I told him I don't ...

**2**

votes

**1**answer

2k views

### Quick/Small Spreadsheet Software

There is some minimalist spreadsheet (excel-like) software? I imagine something like NotePad (small and quick) just to write some tabular data quickly. No toolbars, no font formatting, not "a lot" of ...

**0**

votes

**1**answer

2k views

### In Excel, how do I prevent the cell's formatting to be dragged along?

When working with data, drag-and-drop can dramatically speed up the workflow. Sometimes we work on files which already have their formatting in place, such as borders and colors. When I want to move ...

**0**

votes

**2**answers

995 views

### Excel 2007 pivot table does not aggregate properly

I am using a an excel pivot table to summarize some data and just found a problem. The problem deals with how aggregate values are calculated. Let's say I have a table of data with three columns: ...

**0**

votes

**1**answer

1k views

### How can I sort by word/token in Excel 2011

Is it possible to sort a spreadsheet based on if a word is contained in cells within a column?
Like if I take the "title" column and sort, keeping the rows connected, to bring all the rows with a ...

**0**

votes

**1**answer

5k views

### Excel Pivot Tables — Divide Numerical Column Data into Ranges

I have an Excel spreadsheet with a column called "Time Elapsed" that stores the number of days it took to complete a task.
I would like to make a pivot table out of this spreadsheet where I divide ...

**2**

votes

**2**answers

4k views

### How to reference a cell in a external excel file based on a variable?

Hy I have a Excel File (a) and a cell into it that is equal to another cell in another file (b);
The of the (b) excel file is "2010 something";
Now The cell (c) is ='[2010 something.xls]test'!$K$224
...

**0**

votes

**1**answer

824 views

### Import Paradox db to excel 2007

I have Paradox database (its a file ) which i like to import into excel 2007 but i dont know how. After doing some research i found that i can do this in Ms access when i try to import the database in ...

**4**

votes

**1**answer

7k views

### Converting Unix Time into Human Readable Format in Excel

I have a spreadsheet containing several timestamp columns, given in Unix time, i.e. number of seconds since 01/01/1970 00:00.00 UTC.
Using Excel 2010, are there any methods, and if so how, to ...

**1**

vote

**2**answers

273 views

### I have a sheet that has 2 cols; in one is the name, in the other there are one or more emails, separed by comma

I have an Excel worksheet that has two columns, in one is the name, in the other there are one or more emails, separated by a comma.
Now, I want to get two columns with repeated names but unique ...

**1**

vote

**5**answers

19k views

### Sum if ONLY all the cells have a value?

I need to sum 9 cells of data, each one on a separate sheet, but always in the same location. I only want a figure returned when all the cells have data, even if it's a 0. But, if one of the cells is ...

**0**

votes

**3**answers

197 views

### Excel document cannot open [duplicate]

Possible Duplicate:
Excel document can not open
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 ...

**1**

vote

**2**answers

575 views

### Excel: How do I convert multiple row entries in a column as a percentage of the total entries in another cell?

Example: Under column B
row 10: mop
row 11: top
row 12: cop
row 13: mop
In another cell in another column, I'd like to know the percentage of the word "mop" (50%) and another cell would be the ...

**0**

votes

**1**answer

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

**0**

votes

**2**answers

596 views

### Disallow saving an Excel spreadsheet

Is it possible to disallow saving an Excel (.xls) file?
(Should also work in Numbers on OSX)

**0**

votes

**4**answers

223 views

### How to configure and move text in a raw text file including keeping spaces

What I need to do is move a column of text over to another part of the file; however, each line needs to be a specific amount of spaces at the end and I cannot copy the lone column over because it ...

**1**

vote

**2**answers

4k views

### Excel: How to create a chart that automatically scales the axis

I have 2 columns with values, say A and B which values I want to use as X and Y axes values correspondingly.
The values are the following:
A: 412 684 944 2009 9601
B: 7813,4 10377,6 11138,8 16216 ...

**1**

vote

**2**answers

360 views

### cut text from each line in a txt file

i have a text file where each line looks like this:
<img border=0 width=555 height=555 src=http://websitelinkimagelinkhere>
each line is like that for like 1500 lines, i want to sort of ...

**1**

vote

**2**answers

3k views

### How can I create a formula in Excel that uses DATES?

How do I subtract days from a cell that has dates?
For example, what's a formula that will take 3/2/2011 and return this value 2/28/2011?

**0**

votes

**3**answers

610 views

### Macro is not Cooperating with Quotations in Excel VBA

I Have a macro containing a line that will change the formula of a cell using R1C1 formula type.
The formula is:
ActiveCell.FormulaR1C1 = _
"=IF(R[0]C[-2]=0,"",(R[0]C[-20]-R[0]C[-16]))"
...

**1**

vote

**1**answer

2k views

### Following Excel precedents to cells on other sheets

Let's say I have a cell that references another cell, on a different sheet. For example, cell A2 (of Sheet1) below.
When I press the extremely useful Trace Precedents button, it draws arrows from ...

**0**

votes

**3**answers

641 views

### Open Excel 2003 XML files (XMLSS) in Excel 2000

I need to open Excel 2003 XML files (not Open XML from 2007) in Excel 2000. Is there any plugin that would allow me to do this?
Edit: the name of the format is called XMLSS - XML Spreadsheet

**0**

votes

**4**answers

654 views

### select similar rows in excel 2011

i have a spreadsheet in excel that has about 1500 rows and about 8 columns. One of the columns is headed by 'orderable.' Every cell in this column has either a value '1' or nothing at all. I would ...

**1**

vote

**1**answer

643 views

### Using Excel Linest function without ranges

Is it possible to use the Linest Function when my data is not in a continuous range? I've got my known Y's in J1, J4, J7 etc. and my known X's in A1, A4, A7...
linest(J1, J4, J7, A1, A4, A7) doesn't ...

**3**

votes

**2**answers

5k views

### How to utilize multiple monitors with Microsoft Project 2010 (or other Office 2010 products)?

My question does primarily concern Project 2010, though it would be applicable to other Office products such as Excel, which can tend to span several horizontal screens.
Seems like an obvious ...

**1**

vote

**1**answer

780 views

### Generate a point chart from XML data, possibly with Excel?

I would like to generate some point chart from XML data.
The data should be grouped using color by its "id" attribute. The position is stored in "x" and "y". What software should I use? I tried Excel ...

**1**

vote

**2**answers

999 views

### Extracting RTD (Real Time Data) from Excel file

I have an Excel 2010 file containing auto-updating cells with RTD.
Example of cell:
=RTD("xxx";"yyy")
I need to extract (in a .txt file) those cells' values, every X minutes.
My .txt file MUST ...

**4**

votes

**3**answers

55k views

### How to I auto-refresh an Excel auto-filter when data is changed?

How to I auto-refresh an Excel auto-filter when data is changed?
Use case: I change the value of one cell to a value that was filtered. I want to see the current row disappearing without having to do ...

**53**

votes

**8**answers

82k views

### How to easily reorder rows in excel with drag and drop or move-up or move-down?

I have to do some manual reordering or rows in Excel and cut/paste is too hard to use. I'm looking for something that would enable me to use drag'n'drop or to add some buttons to move-up/down ...

**3**

votes

**1**answer

937 views

### Absolute reference all cell references in a Microsoft Excel formula?

For a Microsoft Formula like this:
=IF(Data!H5=3,0,IF(Data!H5<=Data!H19,3,IF(Data!H5<=Data!H20,2,IF(Data!H5<=Data!H21,1,0))))
Is it possible to mass convert all the relative cell ...

**3**

votes

**2**answers

6k views

### Excel - pivot values in one cell (as comma-separated value)

Excel - pivot values in one cell (as comma-separated value)
I have two columns of data:
Supplier1|Product1
Supplier1|Product2
Supplier1|Product4
Supplier1|Product7
Supplier2|Product3
...

**0**

votes

**2**answers

81 views

### Excel cell autoformatting

I am trying to type the name "True" in a cell and it keeps turning it into a function "TRUE" and I cannot turn off the autoformatting no matter what I try. Help!

**0**

votes

**1**answer

600 views

### Mac Excel SUMIF #NA problem

A formula from a Windows based Excel sheet doesn't work on Excel for OS X:
=SUMIF(P2:P453,"<>#N/A")
The problem seems to be with the "<>#N/A" part.
How should that be written in Excel ...

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

**0**

votes

**3**answers

4k views

### Move markers of line chart/ Format legend

I have a combination chart with a bar chart and 2 line graphs on secondary axis. have to exactly match the formatting in the screenshot attached ( I do not have the actual excel file. just have a ...

**1**

vote

**3**answers

9k views

### How can I merge multiple workbooks into one?

Say I have a directory with the following files:
Workbook1.xlsx (Contains Sheet1, Sheet2 and Sheet3)
Workbook2.xlsx (Contains Sheet4 and Sheet5)
Workbook3.xlsx (Contains Sheet 6)
How can I create ...

**0**

votes

**1**answer

411 views

### Embed web component (text) in excel?

All,
I want to insert some text and number from a given URL into an Excel spreadsheet. Is there a good way to do that?
More specifically, I want to incorporate some of the info in the table ...