excel - rows of duplicate data

  Peter J 19:44 15 Nov 07
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 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
thx

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac