Return Distinct Values Based on Different Criteria

[HeyMike]

Hello,

I am looking for a formula that will return the distinct values of a list based on a criteria.

For example...the formula would go into cell D4, and it would return the distinct "Item Names" in column B based on the "Group" in column A.

Any ideas?

Thanks!
Mike

 

[Weazel]

you can try in D4...

=IFERROR(INDEX($B$4:$B$9,SMALL(IF(FREQUENCY(IF($B$4:$B$9<>"",IF(D$3=$A$4:$A$9,MATCH($B$4:$B$9,$B$4:$B$9,0))),ROW(A$4:A$9)-ROW(A$4)+1),ROW(A$4:A$9)-ROW(A$4)+1),ROWS(D$4:D4))),"") Control Shift Enter

 

[HeyMike]

That worked perfectly, thank you!