Manny
If you use a helper column alongside your current data and enter
=COUNTIF($A$1:$A$1000,=A1)
This assumes you data is in A1:A1000, this will put a number greater than 1
alongside all the dupes, you can then filter or sort by that and delete
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"Manny" wrote in message
...
i want to delete side by side cells that have the same information and
leave
the single entre information cells.
cell 1 = 123
cell 2 = 456
cell 3 = 123
cell 4 = 456
cell 5 = 789
cell 1,2,3,4 would be eliminated and only cell 5 would remain.
Thank you.