Deleting Duplicate Numbers In A Column: How ?
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
Robert11 wrote:
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
|