List unique values from multiple columns

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

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,


2 responses

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
append all 3 columns into one single column and rum command remove duplicates.