Sort the spreadsheet by the column with duplicates in ascending order
In a helper column type-
=IF(A2=A1,1,0)
and copy to the last occupied row
Change the formula to numbers. To do this -

Highlight the helper column
Click on <Edit<Copy<Edit<Paste special<Values<OK
Sort on the helper column
Delete all rows where value in the helper column is 1

Regards.

Bill Ridgeway
Computer Solutions

"PPete" wrote in message
...
I have a list of numbers in a column that can repeat. I want to delete all
rows if that number is repeated.