The 2003 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
1answer
496 views

Microsoft Excel 2003 - Merge by Column

I'm trying to merge two excel files, here is the structure of the files: [A] [B] I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...
46
votes
5answers
67k views

Cells not updating automatically

I seem to have a problem with an excel file. I have a formula in a cell which counts the values in 2 other cells, however, normally after entering in the values in the 2 other cells, the formula cell ...
34
votes
2answers
8k views

Excel: how to undo in current file only?

Microsoft Excel's undo / redo feature behaves unlike any other program I know. The undo stack seems to be global across all open files, so that undoing sometimes switches to another file and undoes ...
12
votes
5answers
59k views

Export an Excel spreadsheet to fixed-width text file?

Excel has the functionality to import fixed-width text files where it presents a dialog that lets you choose where the begins and ends of fields are which it puts into columns. Does it also have ...
4
votes
5answers
17k views

How to avoid double quotes when saving Excel file as Unicode?

I have an Excel file with Unicode content of which some cells contain text inside double quotes, for example "text". When I save the Excel file to a text file in Unicode format, the text which ...
2
votes
7answers
22k views

Adding more than 15 digits in Excel

I want to add more than 20 digits in an Excel cell. The current format of the cell is general, it converts the number to an exponential format. I tried with a number format and accounting, but when I ...
1
vote
1answer
2k views

COUNTIF Duplicate Detection

I have created a formula (excel 2003) to output a "1" if duplicates are found in a column. =IF(COUNTIF(A$2:A$10750,A2)>1,"1","") For some reason this formula does not mark the last duplicate in the ...
0
votes
4answers
2k views

custom format for cells with nothing in them without using conditional formatting

if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...
2
votes
1answer
247 views

how to determine which values in a given set of cells will add up to a numerical range

In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers: 1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16 26 ...
0
votes
1answer
59 views

Weird Excel bar diagram behaviour

I have a very simple question. I wanna have a diagram with the following table Apple 30 40 50 Pears 200 300 400 Bananas 10 20 30 The weird thing, when I try to draw a bar diagram the order ...
9
votes
4answers
30k 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 ...
9
votes
2answers
22k 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 ...
6
votes
3answers
18k views

Why is Excel removing leading leading zeros when displaying CSV data?

I have a CSV text file with the following content: "Col1","Col2" "01",A "2",B "10", C When I open it up with Excel, it displays as shown here: Note that Cell 2A attempts to display "01" as a ...
3
votes
2answers
17k views

Fill an area between two lines in a chart in Excel

There are a lot of hacks to fill the area between two lines in a chart; however, I want one that works seamlessly between 2003/2007 and mac 2011. Preferably, something that is not a hack.
6
votes
2answers
28k views

Merge two excel files using a common column

I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg. The first excel, the 2nd excel 1 t 1 tes1 2 5 3 ...
2
votes
4answers
11k views

Using two conditions with a SUMIF function in Excel 2003

For a given row on Sheet1, I use the SUMIF function to see if the value from the first cell of that row is on a list of historical values in Sheet2. That will basically summarize all the values on my ...
1
vote
5answers
605 views

Unable to create charts for all values in an entire column in Excel 2003

My Excel data looks like this: (it's a lot bigger in fact) code1 code2 01/08 02/08 X A 12 10 X B 8 15 Y A 52 0 Y B 5 5 Every day I ...
0
votes
2answers
1k views

Remove duplicate rows in excel when not all the columns are the same

How can I automatically remove duplicate rows in Excel when data->filter doesn't work, because the columns aren't all the same? I believe the picture explains what I need, but I can probably supply a ...
4
votes
1answer
14k views

How to change font color in Excel based on cell value?

How do you change the font color of a column of cells based on their entered value? I've got a column with the heading at row 1 and the values starting at row 2 going on down. I want to change font ...
2
votes
4answers
20k views

Too much text for an Excel cell — how to make the cell scrollable

What do I do when I have more text in an Excel cell than I want to show in the allocated space? Something making it "scrollable" would be preferred.
2
votes
1answer
1k views

In Excel, how to group data by date, and then do operations on the data?

I have Excel 2003. My data is like this: 01/10/2010 0.99 02/10/2010 1.49 02/10/2010 0.99 02/10/2010 0.99 02/10/2010 0.99 03/10/2010 1.49 03/10/2010 1.49 03/10/2010 0.99 etc. In fact it is a list of ...
1
vote
1answer
610 views

Automatically select last row in a set in Excel

In Excel 2003, I am trying to keep track of some petty cash, and have it set up with the denomination along the top row, along with a sub total and difference column. I want a small section that shows ...
1
vote
1answer
2k views

How to use multiple criteria with COUNTIF?

INPUT: This is the format of the OUTPUT desired: OUTPUT for example INPUT: The problem is, I don't know how to use COUNTIF with several criteria. The "dream function" [that doesn't work] ...
1
vote
4answers
1k views

calculate time differences in excel 2003

I have a goal of 2h47m00s minutes per month. If I attend let's say 1h20m00s and when my Excel cell format is: [Red]-[m]:ss;[Blue][m]:ss ...then it gives me in red color 87 minutes time difference ...
0
votes
1answer
21 views

How do I copy list to another spreadsheet only if items have been paid?

I have a list of invoices. I want only the invoices that have been paid to be copied to another worksheet. My column headings are: Inv. # / Date of Inv. / Amount / Customer Name / Date Paid / ...
0
votes
1answer
71 views

How to extract reminder of a match in MS Excel 2003

I tried using various combinations of functions but it seems that there's no specific function can return non-searched/matched values. Doing it manually takes days cause of the large amount data that ...