XL 2K3 - Compare 2 sheets 1

[MeGustaXL]

Hi all,

I have an existing Excel List of about 1,500 rows.

New list comes in with 1,100 additional items.

What's the quickest, smoothest way to compare the two and come up with a third, combined list with no duplicates?

Cheers Y'all...

Chris

Someday I'll know what I'm donig...damn!

 

[GlennUK]

Copy them so that they are one list, and then do Data/Filter/Advanced filter, action of Copy to another location ( another column in the sheet, with the same header as the list ), and tick the Unique Records Only checkbox.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[MeGustaXL]

Thanks Glenn -> *

I knew that, of course <slinks away in shame>

Chris

Someday I'll know what I'm donig...damn!

 

[GlennUK]

ha ha, thanks for the star ... sometimes the obvious eludes us.

Cheers, Glenn.

Beauty is in the eye of the beerholder.