Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]() Select the target range and run Data|Filter|Advanced Filter with the Unique records only option checked. natan Wrote: 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. -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=319254 |
#3
![]() |
|||
|
|||
![]()
Hi!
Use an advanced filter to extract the unique values and copy them to another column. Then you can delete the column with dupes if you want to. Instructions he http://contextures.com/xladvfilter01.html#FilterUR Biff -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |