Deleting Duplicate Numbers In A Column: How ?
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 |
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 |
All times are GMT +1. The time now is 02:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com