Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
natan
 
Posts: n/a
Default 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.
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default


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   Report Post  
Biff
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Unique Values in Column Kirk P. Excel Discussion (Misc queries) 1 January 25th 05 02:01 PM
can i not allow duplicate values in the same column? excel newbie New Users to Excel 2 January 20th 05 07:51 PM
How do you find duplicate values in excel- 2 columns of numbers rickmanz Excel Discussion (Misc queries) 1 December 15th 04 11:16 PM
Last several values in a column Mike K Excel Worksheet Functions 2 November 19th 04 12:13 PM
Can you average data in 1 column based on a range of values in another? kman24 Excel Worksheet Functions 2 November 17th 04 02:09 PM


All times are GMT +1. The time now is 08:08 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"