I have a list in column C that has thousands of different company names  
and I am trying to see which names in column C match up with the names in
column B which has hundreds of names.

Find it hard to believe that Excel doesn't have the exlusive OR
funcion.
I need something to say either A or B but NOT both.  I suppose can
write a longer formula to achieve this but.... :confused:

I have this formula: =IF(M8>1,"Budget
Made",ABS(M8/(COUNTIF(July!K3:K20,"=")))), which seems to work if July!K3:K20
were numbers I manually typed in but the truth is K3 contains the formula:
=IF(J3<1," ",(SUM(I3:J3))) all the way to K20 - and I get the #DIV/0 error.  

What formula do I use to return the lowest value whether numeric or character
in the column?

I'd like to record employee absences on Excel and get totals of both number
of days & number of times (frequency) an employee has been absent. e.g.:
Apr = 3+1 (No. of days off = 4 & frequency = 2)
May = 1+ 1  (No. of days off = 2 & frequency = 2)

I have a worksheet with many excel spreadsheets in them. This is what I want
to do. I am looking for a formula that will move a number from one
spreadsheet to another. For example, I have spreadsheets A, B, C & D.
Numbers that I need in spreadsheet A are in B & C. What formula ...

I get an Excel spreadsheet report that I need to bring over the store number
to and existing report. The common field for both is the client number. I get
this report every week and would like to automate the process. Right now I
have to go line by line through hundreds of stores ...

Hello, I have been reading a lot of the Q&A here, but I haven't found one
that worked perfectly for my spreadsheet.  I even went to the Pearson site,
but I didn't have any luck with the formulas.
GOAL:  Multi-function cell

can anybody tell me how to create a list box with some data so that i can be
able to select several items in the list and the strings that are selected
to form an array.
Thanks in advance

I am trying to count criteria from two different columns and have th
answer appear on a different worksheet.
Here is the formula I have used:
=SUMPRODUCT(--('MAIN'!C2:C65534="Phas

If cell A4 has a value of 0. I am looking for the entire row to be
deleted.
Please help:( :(

I need to extract a persons name from a cell that has the filename
for instance =cell("filename") will return  T:\actdata\act\excelshets\[abbey
roberts gymstart progress 2006.xls]sheets1
I want just the name I.e abbey roberts

In a “standard” worksheet table, I want to sort all of the data (using the
Header Row).  I then want to take a chunk of this data, and sort it (No
Header Row).
Is there a way to save sort criteria?  For example, could I save Sort

I have the following question:
I have about 2000 records in Column 1 (a code consisting of letters and
numbers). In Column 2 I have about 1500 records. All of the records in
Column 2 are contained in Column 1. However, since about 500 are

I will have a spreadseet that is approximately 3,000 rows. In Column A, the
user will be entering an account number . There might be 100 unique account
numbers.
I am looking for either a formula or a macro that will automatically display