Formula to delete every second row

[Berno]

Hi there,

I have a spreadsheet with duplicate data on every second row, just wondering if anyone knows of a formula that will delete every second row...

Thanks!

 

[Beezkneez]

Well formulas dont delete so if you are just looking for an easy way to identify what you need to delete, add a formula to an empty column that says
=A1=A2
Then copy the formula down the length of the data.
Every duplicate row will return TRUE.
Then using a data filter, you can filter and delete all the TRUEs.

 

[swinglow]

If your data is unsorted:

If column A has the unique identifier:

enter this formula into row one in an available column, and drag down all of the rows:
=COUNTIF($A$1:A1,A1)

That will number each record (first occurance of a dupe will have a 1, second occurance will have a 2, and so on)

Copy all of the formulas that you just entered then Paste Special... Values
Now you can sort on that column and delete all rows that have a number greater than 1

 

[Blade Hunter]

Highlight it, apply an advanced filter, choose Copy to another location, choose where to copy it and tick Unique records only.

 

[Berno]

THANK YOU THANK YOU THANK YOU!!

You have saved me lots of time!

Very much appreciated!