List unique values from multiple columns

Closed
Socio - Oct 16, 2009 at 03:32 AM
 Swami - Aug 20, 2010 at 12:12 PM
Hello,

I am kind of new in advanced programming with Excel.

I have a table that gathers a number of sentences which I classify with 3 category columns.

Eg.: Sentence / Category Level 1 / Category Level 2 / Category Level 3

This categories are different for each sentence, but they can repeat themselves across the 3 columns and in different levels.

What I'm trying to do is create one column in another worksheet that lists the values from those 3 columns without duplicated values.

Is this possible to do? How can I do this?

Thanks a lot in advance. I'll appreciate any kind of help. I really need it.

Best regards,

Socio

2 replies

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 19, 2009 at 08:12 AM
Hello there,
A workaround
In a blank column put the formula = if(A1&B1&C1 =A2&B2&C2,"",1)
where A1, B1 & C1 refer to your three categories
Filter to remove blanks
6
append all 3 columns into one single column and rum command remove duplicates.
5