excel - rows of duplicate data

  Peter J 19:44 15 Nov 07

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.

  VoG II 19:50 15 Nov 07

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 07

thanks vog
as always a quick and accurate reply

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…