Duplicate remover (no macro)

  • Thread starter Thread starter RyanR8881
  • Start date Start date
R

RyanR8881

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel 2007: Help creating a macro that will run Solver? 3
Complex formula help , please. 13
Macro to copy value in field and insert it into filter 2
Separating data into new sheet 1
Excel vba code to match duplicates 4
Excel If a Cell Contains a Certain Text (From Another Table) 0
Yes no drop down list and macros 4

Back
Top