Using Advance filtering technique

so that all the column information are retrieved even if the typed cells are
misspelled, which normally is not the case when you do a simple filtering
technique. The filtered values may not be correct.

To retieve the values;

1. Select all records and the column headings and define a name for the
range List. This is the List range name.
2. Select all column headings and paste in a seperate row anywhere in the
spreadsheet.
2. Select the pasted column heading along with an empty row and define a
name. This is the criteria range name.
3. Define a criteria on the second row for all columns, if necessary. For
example S* will display all details specific to "S'.
4. Click Data- Filter- Advanced Filter
5. Type the List name
6. Type the Criteria Name
7. Click copy to another location option - Mandatory
8. Click Copy to
9. Click the cell below the criteria range

All data will be displayed specific to the query you requested. This is very
usefull if the spreadsheet data are mistyped or mis-spelled. Now you have
done a database funtion on your excle spread sheet.

Challa Prabhu


"Stephanie" wrote:

Hello- my first post to the Excel group. I'm new on 2003 (SP2).

I have existing records of FirstName, LastName and Company.
I'm planning to upload additional records of FirstName, LastName and Company
and want to make sure that I don't upload any already exisiting records.

How can I compare FirstName, LastName and Company from one file (all 3
together would make the record "unique") against FirstName, LastName and
Company from another file?
Thanks for your help!