L2=IF(J2="","",IFERROR(LOOKUP(1,0/(LOOKUP(ROW(3:9),ROW(3:9)/(A$3:A$9<>""),A$3:A$9)=J2)/(B$3:B$9=K2),ROW($3:$9)),"無此水果"))
L14=IF(J14="","",IFERROR(ADDRESS(SUMPRODUCT((B$13:H$13=J14)*(B$14:H$15=K14)*ROW($14:$15)),SUMPRODUCT((B$13:H$13=J14)*(B$14:H$15=K14)*COLUMN(B:H)),4),"無此水果"))
留言
張貼留言