Hi Billy

Maybe you can try to use pivotable

Oscar


Billy wrote in message
...
This should be simple. I have a spreadsheet with one column and several
thousand rows. Each cell contains a phone number. I want to delete all
but
one of each duplicate number so that I end up with all unique numbers.
How
can this be done quickly?