If I have two sheets. One sheet a.) lists 1000 addresses, and sheet b.)
lists 400 address from sheet a.). How can I create a formula that extracts
or eleminates the 400 specified properties on sheet a.)
No macro solutions please. I'm an excel 2003 user.

Hi

In the large list, use a COUNTIF function in the next column to see whether
the address is in the short list (0) of not (=0)

Then use an autofilter or an advanced filter to delete the rows that exist
in the short list.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"RyanR8881" wrote:

If I have two sheets. One sheet a.) lists 1000 addresses, and sheet b.)
lists 400 address from sheet a.). How can I create a formula that extracts
or eleminates the 400 specified properties on sheet a.)
No macro solutions please. I'm an excel 2003 user.