Deleting Duplicate Numbers In A Column: How ?

[Robert11]

Hello,

Have a long list of numbers, formatted the same, in a column.

Would like to delete duplicate numbers.

How can I do this, please ?

Thanks,
Bob

 

[Pete_UK]

Is this the only data in your sheet? If so, then enter a heading in A1
if you don't already have one (insert a new row 1 if necessary). Then
highlight all the data including the heading and click Data | Filter |
Advanced Filter - here you can specify to filter in place and to have
Unique Records only, and then click OK.

Hope this helps.

Pete