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)

3
votes
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
3answers
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
5answers
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
1answer
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
2answers
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
3answers
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
1answer
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
4answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
5answers
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
3answers
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
2answers
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
1answer
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
2answers
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
4answers
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
2answers
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
2answers
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
2answers
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
3answers
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
1answer
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
3answers
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
4answers
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
1answer
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
2answers
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
1answer
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
2answers
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
3answers
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
8answers
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
1answer
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
2answers
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
2answers
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
1answer
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
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.
0
votes
3answers
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
3answers
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
1answer
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 ...