1

Use ifs(), like this: =ifs( not(isnumber(B2)); iferror(1/0); B2 < 900; "(leptonic)"; B2 <= 1400; "Small"; B2 <= 2000; "Medium"; true; "Large" )


1

In D2: =UNIQUE(FILTER(A2:B,C2:C="Q"))


Only top voted, non community-wiki answers of a minimum length are eligible