# Returning only unique results based on multiple conditions

1. ## Returning only unique results based on multiple conditions

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!

2. ## Re: Returning only unique results based on multiple conditions

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.

3. ## Re: Returning only unique results based on multiple conditions

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.

5. ## Re: Returning only unique results based on multiple conditions

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.

6. ## Re: Returning only unique results based on multiple conditions - Solved

Thank you gentlemen, That solution worked for me.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1