Deleting Duplicate Numbers In A Column: How ?

  • Thread starter Thread starter Robert11
  • Start date Start date
R

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
 
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
 
Back
Top