Matching and Ranking

=IF(ISERROR(SMALL(OFFSET($D$3,COUNTIF(A:A,$AA$1)+COUNTIF(A:A,$AB$1),0,COUNTIF(A:A,$AC$1),1),ROW(M1))),"",SMALL(OFFSET($D$3,COUNTIF(A:A,$AA$1)+COUNTIF(A:A,$AB$1),0,COUNTIF(A:A,$AC$1),1),ROW(M1)))

Where: cell AA1="Type A", AB1="Type B" AC1="Type C"

Obviously you can choose any three cells that are nicely convenient for you rather than AA1 AB1 and AC1.

You can then set the three criteria to be whatever you want.

Hi Mark@Work,

Great idea! I will try your suggestion...

Have a great weekend,
Joe