The 2003 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
1answer
353 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 ...
1
vote
1answer
1k 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
3answers
1k 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
137 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
57 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 ...
6
votes
4answers
17k 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 ...
5
votes
2answers
10k 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 ...
12
votes
5answers
39k 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 ...
2
votes
4answers
9k 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
552 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
858 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

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 ...
4
votes
1answer
10k 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
8k 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
971 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
305 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 ...