二項條件設定 設不設均可 取非空資料 (13393)

J2 下拉{=IFERROR(IF(AND(H$2:H$3=""),"",INDIRECT(TEXT(SMALL(IF((A$2:A$17=IF(H$2="",A$2:A$17,H$2))*(B$2:B$17=IF(H$3="",B$2:B$17,H$3))*(C$2:E$17<>""),ROW($2:$17)/1%+{3,4,5}),ROW(A1)),"!R0C00"),)),"")