List unique values from multiple columns

 Swami -

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 replies

Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

append all 3 columns into one single column and rum command remove duplicates.