Thanks for the quick response Oscar, but I am quite a novice. I have no
idea what a pivot table is. I just thought there might be a function or
macro I could run to do this.

Billy

"oscar" wrote in message
...
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?