I have a situation with an input sheet where they put in a division name,
product name, month put in service, and quantity put in service in that
month. The names are picked from validated lists, the month can be 1-60 for a
five year span, and the quantity can be negative or ...

I'm having a bit of a problem that I hope that someone can help me
with. Here's my sample data range:
City,  Rate
Chicago,   50

I know how to obtain name of worksheets in the same worksheet.
Following function will do this.
MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
I want to obtain name of all worksheets in one sheet. How can I do it.

Here's my sheet
Company|Zone | Units
________________
    A       |   1    |   3

Hi helpful people,
I have imported a list of mailing labels. So all the data for each
vendor is in separate rows, in one columns. I want to make these into
different columns.

Can you copy conditional formatting down a column, and have it change the
cell references like it does with regular formulas?
Cell P2 changes formatting depending on the value of cell I2; Cell P3
changes formatting depending on the value of cell I3; etc.  

I have a pivot table sorted by two fields; budget unit and employee name.  My
source data has each employee with several rows of data (so the names show up
several times).  I need a count of employees in each budget unit, not a count
of the occurence of the employee name. How do ...

I have created a formula in Excel 2003 for getting Pivot Table Data that
doesn't work in 2000. The formula for 2000 seems to be wanting a text string,
but the variable that needs to be looked up everytime is changing...
Here is the formula in 2003:

I have a spreadsheet with over 3500 rows (not really a lot) but the
Autofilter drop down list does not show them all. It only shows approximately
2400 rows. Is there a limit to the number of rows that autofilter can be used
on?

If I have a colomn of gray cells, how can I have them go white when any data
is entered in that cell?  Conditional formating isn't working.  Thanks in
advance!

I've been trying to enter a person's name (Liev) into the spread sheet.  The
system keeps "correcting" it to Live.  How do I turn off that function so
that I can enter the name correctly?

I am trying to find the earliest date that falls within date range that
matches an employees name. .    M$2 is today's date and N$2 contains a
date 3 years earlier.  "names" is the range of employees and
"accident_dates" contains the dates

I have a column of data.
I want to reverse it. Is it possible?
as
ab

I have a list in column a - the only thing on the sheet.
I want to move it so that it becomes a row.
ie I want A1 to stay put.
I want A2 to move to B1, A3 to C1, etc.  Is there a simple code that will do

Using Excel 2000 - I have 2700+ rows of data to analyze, spreadsheet has 15
columns of data.  I want to count the rows which meet particular criteria for
the "year" column (number formatted cells) and and the "Semi" column, also a
number formatted cells.  I just want a count of ...