LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Remove Duplicate Entries

Hi All,

I am asking too many questions but so does a child who learns
something new :-)

I have 5 columns of data. Each columns has different number of data
starting row 2. Row 1 has the column heading.

Column 1 has 34 data (which may vary)
Column 1 has 64 data (which may vary)
Column 1 has 13 data (which may vary)
Column 1 has 11 data (which may vary)
Column 1 has 37 data (which may vary)

In each column, some of the data is duplicate.

I need to generate a list with all the duplicate entries removed.

Assuming each of the 5 columns above has 10 original data only, then
my output should be 5 columns of data with 10 entries each.

Thanks in advance,
Anshuman

 
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
Duplicate Entries Phxlatinoboi® Excel Discussion (Misc queries) 2 August 24th 06 01:17 AM
Duplicate Entries ConfusedNHouston Excel Discussion (Misc queries) 1 November 1st 05 12:50 PM
How do I remove duplicate entries from a list? E. Reta Excel Discussion (Misc queries) 1 August 24th 05 06:37 PM
How to remove duplicate entries in column? [email protected] Excel Discussion (Misc queries) 1 June 24th 05 09:23 PM
Duplicate entries Keggarboy New Users to Excel 3 April 30th 05 08:26 AM


All times are GMT +1. The time now is 11:36 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"