Duplicate Cells

[Lanny]

I have a very large, 2 column spread sheet. Every other
row is a duplicate. How can i, easily delete the duplicate
rows and/or cells?

 

[Serkan]

sorry i made a mistake.
it isn't work.

 

[Andy B]

Lanny

Assuming that it is every other row you want to keep, use a column alongside
your data and put
=MOD(ROW(),2)
and fill this down. Select the column of results, Copy, Paste
Special/Values. You can now sort on this column to split the duplicates and
delete as necessary.

Andy