excel - rows of duplicate data

  Peter J 19:44 15 Nov 2007
Locked

Hi,
i have a spreadsheet where in columns a-d there are many rows with duplicate data. How can i remove these duplicates and leave one unique row.
Cheers

  VoG II 19:50 15 Nov 2007

Make sure that your list has a headings row. Select all the data including headings. Data > Filter > Advanced Filter. Tick 'Copy to another location' and 'Unique records only'.

  Peter J 19:53 15 Nov 2007

thanks vog
as always a quick and accurate reply
thx

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

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?