Search : in
By :

List unique values from multiple columns

Last answer on Oct 19, 2009 1:12:59 pm BST Socio, on Oct 16, 2009 8:32:17 am BST 
 Report this message to moderators

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

Configuration: Apple Mac OS X
Microsoft Excel 2007
Firefox

1

 Excelguru, on Oct 19, 2009 1:12:59 pm BST

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 A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
I am interested in financial Modelling and custom excel development with excel macros.

Reply to Excelguru