Creating a list where entries meet specific criteria

Hi Andrew,

For data like this

the formula could like

for Small in F2

=IFERROR(LOOKUP(2,1/(COUNTIF($F$1:$F1,$A$2:$A$20)=0)/($A$2:$A$20<>"")/($C$2:$C$20="Small"),$A$2:$A$20),"")

for Large in I2

=IFERROR(LOOKUP(2,1/(COUNTIF($I$1:$I1,$A$2:$A$20)=0)/($A$2:$A$20<>"")/($C$2:$C$20="Large"),$A$2:$A$20),"")

and drag them down. Adjust the ranges for the real data.

Attached.