WHAT IS A HELPER COLUMN? DO I PUT THE FORMULA IN COLUMN A?

"Nick Hodge" wrote:

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.