INDEX/MATCH single occurrence

[donjamin]

Hello All,

Hoping for your kind help here.

Effectively, I'm trying to extract a unique list of single occurrence values from Col D in DATA tab into Col D in Sheet1, with the additional requirement that text in Col H in DATA tab matches the text in Sheet1 $N$1. I'm using the following formula, however, it's still not listing just the single occurrence values:

=INDEX(DATA!$B$2:$B$30,MATCH(0,COUNTIF($D$1:D1,DATA!$B$2:$B$30)+IF(DATA!$H$2:$H$30=Sheet1!$N$1,1,0)))

Perhaps it's a SMALL formula I should be using but I'm stuck here

Appreciate any help you can provide!

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Administrative Note

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.