Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Entries | Excel Discussion (Misc queries) | |||
Duplicate Entries | Excel Discussion (Misc queries) | |||
How do I remove duplicate entries from a list? | Excel Discussion (Misc queries) | |||
How to remove duplicate entries in column? | Excel Discussion (Misc queries) | |||
Duplicate entries | New Users to Excel |