Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spacing numbers in 1st column by inch intervals of 2nd column | Excel Worksheet Functions | |||
placing numbers in one column at intervals of 2nd | Excel Discussion (Misc queries) | |||
Dame: identifying duplicate numbers within a column | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
How do I prevent duplicate numbers from being entered in a column. | Excel Discussion (Misc queries) |