复合筛选 (9866)


K2:M21{=INDEX(C:C,SMALL(IF(($D$2:$D$21=$G$2)+ISNUMBER(MATCH($E$2:$E$21&"V",$H$2:$H$6&$I$2:$I$6,))+($G$2=""),ROW($2:$21),99),ROW(A1)))&""


 


留言