Software

Ask something
Discussion Locked

Excel comparison

0 helpful
9 replies

by dschwer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all

Is there a way to compare 2 excel spreadsheets. I have 2 spreadsheets that are mailing lists that i need to compare a column in each, remove duplicate entries and then create a third sheet with the comparison. Is this possible

Thanks

9 replies

by sgt_shultz

i don't know how to do this in Excel but if you have Access, import both spreadsheets into one table, create a second copy of the table, but structure only, no data. make the primary key the field with the duplicate values. import the table consisting of the combined spreadsheets and since primary key won't allow duplicates, only the first occurance of duplicate records will be imported. export back into Excel....

This discussion is closed to new replies.