View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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