When doing an "AutoSum" is there a way to being forward the "Fill Color"
within the anchor cell?
Any help would be greatly appreciated.
Tom

I would like to enter names and mailing addresses with column headings such
as fname,lname, address, city, state, zip and have Excel look up the county
where the zip code is located and enter the county name into the same row in
a "county" column.  This has to be easier than I am ...

Anybody care to help?  Much Mahalos (thanks very much) in advance for trying.
I want to be able to gather data from specific cells within multiple excel
spreadsheet files and have them appear on another excel file that will be a
summary list of all the data collected from the ...

I need to have a validation between two date columns so if the date is
greater than 90 days, it can either stop the user or flag the user.Can this
be done?

Want to create a formula in Excel which tests for the existence of a second
Excel file.  If the file does not exist (because it hasn't yet been created)
the formula should return a False value which can then be used to create a
blank cell rather than a cell containing an error ...

I apologize for this stupid question, but I'm trying to calculate the mean of
the following cells and format it into a percentage
E3 189
F3 93%

I am trying to write my first UDF and am hitting a snag. I need to pass a
worksheet name as one of the arguments (referenced in a cell). Function keeps
giving me zeros! I have multiple worksheets with result data and in a summary
sheet I want to use my UDF to "gather" this info ...

When using the autofill function to copy a formula down a column, only the
data is being copied so when you click onn on of the filled cells the formula
is correct but the data is a copy of the first cell only.

I think I am going to have to use a macro to perform this function but I
really only know how to record one with the button.  What code do I use to
complete this task.  I have a data set with more than one column and more
than one row of data.  The worksheet shows several rows ...

I would like to compare the data in 3 cells. I want the data that doesn't
match to be highlighted. How do I do this?

example: I have 1000 sorted records. I have 5 employees. I want 1st record to
go to emp 1; 2nd record to emp 2 ... 5th record to 5th emp. Then I want to
start new assignment of records: emp 2 gets 1st rec; emp 3 gets 2nd rec....
emp 1 gets 5th record, thus rotating which emp gets ...

Does a higher 'covariance' number indicate a greater disparity between 2 data
sets?
When I calculated 'correlation' for the same dataset, the stronger
correlation was actually found on those datasets that had higher covariance.

In Excel 2003, I have a range 50 columns wide and 600 rows tall.  Row 1 has
the column headings, while Rows 2-600 contain the data pertaining to the
column heading shown in Row 1.
Now I want to sort the entire range according to the column headings, so

I'm trying to use the MIN function to retrieve the smallest bid amount
in a document (ex =MIN(B60,J60,N60,R60,V60)). The cells I'm retrieving
from contain the SUM formula to get the total bid amount (ex
=+B46+B58).

Hi. Please help. I have an excel sheet with mulitple worksheets.  I need to
protect one of them and keep the rest open and available. The worksheet that
I need protected can not be seen at all.  Does excel have an option to prompt
me for a password each time the worksheet is ...