Deleting unique cells in two lists

[LilyLilyRose]

I have two very large lists in an excel spreadsheet. I'd like a way to delete
cells in one list that aren't located in the other list. For example I have
A1:A1000 and B1:B1500. There are 500 extra cells in column B that aren't
located in column A and I would like to remove those extra 500. Is there a
formula or a macro that I could use? I have some experience with macros and
almost no experience at all with visual basic. I'm using Excel 2002.

[Norman Jones]

Hi LilyLilyRose,

See Chip Pearson at:

http://www.cpearson.com/excel/duplic...gingDuplicates

See particularly the sections entitled 'Extracting Values Common To Two
Lists' and 'Extracting Values On One List And Not Another' at the foot of
that page.


---
Regards,
Norman



"LilyLilyRose" <[email protected]> wrote in message
news:[email protected]...
>I have two very large lists in an excel spreadsheet. I'd like a way to
>delete
> cells in one list that aren't located in the other list. For example I
> have
> A1:A1000 and B1:B1500. There are 500 extra cells in column B that aren't
> located in column A and I would like to remove those extra 500. Is there a
> formula or a macro that I could use? I have some experience with macros
> and
> almost no experience at all with visual basic. I'm using Excel 2002.