| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Removing duplicate values in a column
How do I remove duplivate values in a column. eg. if i have the following
values in a column, 1,2,2,2,2,3,3,4,5,6,7. I wantto remove the duplicates to en up with 1,2,3,4,5,6,7 in the column, without empty cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Unique Values in Column | Excel Discussion (Misc queries) | |||
| can i not allow duplicate values in the same column? | New Users to Excel | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| Last several values in a column | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
