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.

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

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.
.