Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
RMN RMN is offline
Junior Member
 
Posts: 3
Question Deleting duplicates within a column?

If I have, for example:

4,2,,3,2,,,,,,9,9
6,44,,,,,,9,12,6
ee,3,22,22,22,22

and I want to delete the duplicate numbers and commas so that it looks like:

4,2,3,9
6,44,9,12
ee,3,22


Is there a way to do this and apply it to an entire column? There are nearly 10,000 rows in this column and they are all different, so it will be very time-consuming to do it by hand.

Thanks a lot! :D
  #2   Report Post  
RMN RMN is offline
Junior Member
 
Posts: 3
Thumbs up

In case anyone has this question in the future, I figured out a way:

Select the entire column and go to Data--text to columns--Delimited, and select the appropriate separators (in this case, commas and spaces). This will put each number in its own cell.

Use:
=IF(COUNTIF($A1:A1,A1)=1, A1,"")

Drag it over to the right as many columns as necessary, and then drag it down as many rows as necessary. Any duplicates will be blank.

Select all of them, copy, paste special, "values."

Use MCONCAT to combine them again and voila! :D
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
Deleting Duplicates Angie M. Excel Worksheet Functions 2 February 4th 10 03:55 PM
Deleting Duplicates Jane Excel Discussion (Misc queries) 3 August 17th 07 02:58 AM
Finding and Deleting duplicates in a column Brian Excel Worksheet Functions 3 February 5th 05 02:19 PM
Deleting Duplicates halem2[_46_] Excel Programming 1 October 19th 04 10:28 PM
Deleting Duplicates halem2[_45_] Excel Programming 1 October 19th 04 09:11 PM


All times are GMT +1. The time now is 11:49 PM.

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

About Us

"It's about Microsoft Excel"