View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
anshu[_2_] anshu[_2_] is offline
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