Hi, wonder if you can help
In A1 I have a number in b1 I have two letter. All going downwards
A1     B1
5       AA

I am trying to reconcile 2 xl files and need to generate two lists of items
not included on the other worksheet. ie.  On file 1 not on file 2, and, on
file 2 not on file 1.
Both files have two colums. Column A is a 6 digit number and column B is a

I generated a correlation matrix using tools, data analysis, correlation.
But nowhere does it say.   Is the table of correlation coefficients that
resulted composed of univariate, or multivariate, correlation coefficients?

I have a spreadsheet with tariff numbers in a column already in the following
format: 9018.90.8000 and I want to be able to:
1. eliminate the "periods" in the current column
2. once I enter new tariffs have the column formatted (line you can social

Pivot table gives a "Grand Total" of all rows at the end of row. Each time I
run a Pivot Table, the Grand Total Column is changing from column to column.
Some time the Grand Total can be find in col "O", "P", "Q" or "R" due to what
is being fetched. What type of formula can be ...

I know how to lock cells... my question is:
I have vlookup formulas in a document that I emailed from work to my home
email address.  At hoem, the formula now includes the temp email file
location.

Unbeknownst to each other, two of us have been updating a worksheet which has
27000 records and about 10 fields to each record.  The changes are not
extensive, but need tobe identified and resolved between the two versions.  
The changes could be in any of the rows or columns.  I ...

This has me baffled and I would greatly appreciate some help.
Column E contains URLs, and I'm trying to use the hyperlink function to create
hyperlinks in column F.
For example:

I have 17 sheets, the 17th one is the Summary sheet. Now in the cell B2 of
the 17th sheet I want to calculate the average of the cells B2 in all the 16
sheets, what will be the easiest way to do it? the sheet tabs are named as
Agent 1.......Agent 16.

I am trying to have cell in colum A summed IF the corresponding cell in colum
B is the same as a specific cell D4.  Data looks like this.
Data to be summed    If cells here are the same as     The cells here
55                                                    1    0

I'm having a little trouble with a lookup function I'm trying to write.  
Hoping someone could set me straight on what I'm doing wrong:
on one tab of a worksheet I have a column (B) into which I type a "job
number".  I want column C to look at Col B and return the "job name" for ...

I need some help with Conditional Formatting, please.
I have a spreadsheet used to track data relating to reports prepared for
clients.  Column F on each row contains the date the report is due.   Column
G contains the actual date when the completed report is submitted.

I have two ranges that contain placeholders for project labor (hours)
estimates:
C10:N10 (representing Jan - Dec 2007)
C20:N20 (representing Jan - Dec 2008)

I used a UDF to enter the last modified date into a section of the custom
footer.  Works great.
I want to add a separate line of text to the section of the footer
containing the modified date.  Like this:

I have some info that is only seperated by commas not in tabs to columns, is
there a way to put it into tabs/columns? I know I can save as tab deleted put
I have no idea how to put it back into tab/columns!!!
Also is there somewhere where I can redownload Excel? It came on my ...