Excel spreadsheets - find duplicate entries?

  lindyloo4 18:53 26 Jun 2006

We have a spreadsheet at work with 1800 names and addresses on of people who have to be contacted. We are to be sent another with probably the same number of names on.
Is there anyway we can check for duplicate entries?

Ideally we would be left with only names and addresses of people we have yet to contact.
Incase you need to know the forenames are in one column, surnames in another, street in another, town in another, etc.

If you can help, very simple language please. I'm not very good at excel. We are not allowed to download anything either.

Thanks in advance.

  Noldi 19:22 26 Jun 2006

Sort the surname coloumn then you would see the duplicates together.
Data - Sort
I have another way that I sort lists from SAP but this uses a macro and I think you are looking for a simple answer


  lindyloo4 20:07 26 Jun 2006

Noldi, thanks. I'd thought of using sort but realised I'd be left with the single entries between the duplicates and I need to mail merge when completed.

VoG™, That's just what I needed. Thanks very much.
Hope you enjoyed Teneriffe!!!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Threadripper 2990WX review

George Bletsis' illustrations capture character and chaos with an effortless touch

iMac at 20: 10 iMac facts and history in pictures

Comment supprimer son historique Netflix ?