Returning only unique results based on multiple conditions

**Dickens153** · 03-13-2012, 03:38 PM

Hello,

I have a file that is pulling in catalog information from another excel file. I am interested in creating a formula that pulls in only the unique results based upon multiple criteria.

For example

Line 1 A X 5
Linie 2 A X 5
Line 3 A X 6
Line 4 A X 6

How do I look up the criteria for "A" and "X" and only return the 5 and the 6 as unique results based on that combination of criteria?

Many Thanks!

**Dionysos** · 03-13-2012, 05:40 PM

Under the Data tab, there is a "Remove Duplicates" button in 2007. You can specify which columns should be checked for duplicate information. If you don't want to delete any of the original data, copy the worksheet first.

**Dickens153** · 03-15-2012, 03:47 PM

Thank you - that's a simple solution to the format that may solve my problem.

Do you have a formula that will return only the "5" and "6" in the original example?

Thanks again.

**FDibbins** · 03-15-2012, 05:15 PM

=right(cell_address/text,number_of_places)

**Haseeb Avarakkan** · 03-15-2012, 06:11 PM

Assume data is in A2:C100,

In E2 with CTRL+SHIFT+ENTER, rather than just ENTER

=IFERROR(INDEX(C$2:C$100,MATCH(1,IF(A$2:A$100&"_"&B$2:B$100="A_X",IF(ISNA(MATCH(C$2:C$100,E$1:E1,0)),1)),0)),"")

E1 must be an unique value NOT in C2:C100 eg: #Unique# or leave it blank. Then copy down.