i have a column with race information in it  for example
black     1
white    2
asian    3

Am bussy compiling a summary of certificates and can't get excel to number
up automatically when I copy (pull down with mouse) the cell. I need the same
cells from different certificates. It keeps certificate one and I have to
change it all by hand for a dozen colums.

I am building a load file for our ERP system and I'm setting it up in Excel.  
However the final load file will be a txt file.  Formatting is obviously very
crucial for that text file.  So far, I've saved the Excel data as every kind
of txt file I can find and I've saved it as a ...

Is there a function similar to "Insert-Name-Paste-Paste List" for pivot
tables, where I can generate a list of all pivot tables and where they are
located in the spreadsheet?

Don't know if it is sumproduct that would do what I want, but from
looking into previous posts this appears like it would be possible?
I have a list of data in columns A:C.  What I need to be able to do is
count the number of unique approvers (column C) by the Purchase Order

Excel 2003 question.
Hello,
I have a file with about 200 names. I pasted the list of these names
(Insert/Name/Paste...) in a tab. In the first column, there are the names and

If I have 3 columns:    
NAME              LOCATION     YEARS IN COMPANY
Doe, John             Franktown                 1
Doe, Joan             Franktown                 2

Does any one know of Excel Template that will Gross up Taxes and calculate a
Paycheck?
Any help much appreciated.

In Column D I have the text Green, red or yellow.  My question is how do I
display the Green Stoplight, Red Stoplight or yellow Stoplight?
CB

In an Excel 2007 spreadsheet I have a column of numbers that is incremented
each month.  I would like to have the largest number in that column -- which
may change from month to month -- appear in read not black.  How do I write a
formula to do that, or how otherwise do I do it?

I am using a spreadsheet that imports data from our Traffic System. One of
the fields pulls through a 3 letter field but also pulls through a list of
0's and the odd letter after it which we do not need.
I can seperate these with Text to Column so one column just shows the 3

I have 2 columns
   A   B
1  a   a
2  d   d

I want to reuse a table for my tax returns for last year but without
the data entries.  I need to keep the underlying formulae, so how do I
save a copy of the existing one, empty the cells but leave the
framework - columns, cell functions etc so I can start the new year

I need to sort my numbers-as-text at the end of the list, and I can't figure
out where to change it.

Hello Group
I have noticed that some of the software for DOE are using excel as
platform, therefore this led me to ask is there a way to just use
just  excel 2003 or 2007 to create  experimental design in many