Board logo

¼ÐÃD: Âù±ø¥ó²Å¦X±a¥X­È(Àx¦s®æ¦³¦X¨ÖÀx¦s®æ) [¥´¦L¥»­¶]

§@ªÌ: leiru    ®É¶¡: 2020-8-17 21:05     ¼ÐÃD: Âù±ø¥ó²Å¦X±a¥X­È(Àx¦s®æ¦³¦X¨ÖÀx¦s®æ)

°ÝÃD:
EÄæ²Å¦XCÄæ¤ÎFÄæ²Å¦XAÄæ¡A¦bGÄæ±a¥XBÄæ¸ê®Æ
§@ªÌ: ­ã´£³¡ªL    ®É¶¡: 2020-8-19 10:35

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2020-8-19 10:41 ½s¿è

°}¦C¤½¦¡(¤TÁä)
=IFERROR(IF(OR(E2="",F2=""),"",LOOKUP("ùÜ",B$1:INDEX(B:B,MATCH(,0/(LOOKUP(ROW($1:$99),ROW($1:$99)/(A$1:A$99<>""),A$1:A$99)&C$1:C$99=F2&E2),)))),"")
§@ªÌ: Hsieh    ®É¶¡: 2020-8-29 16:03

¦^´_ 1# leiru
G2=LOOKUP("ùÕ",OFFSET($B$1,MATCH(F2,A:A,0)-1,,IFERROR(MATCH("*",OFFSET($A$1,MATCH(F2,A:A,0),,5000,1),),LOOKUP("ùÕ",OFFSET($C$1,MATCH(F2,A:A,0)-1,,500,1),ROW($1:$5000))),1))




Åwªï¥úÁ{ ³Â»¶®a±Ú°Q½×ª©ª© (http://forum.twbts.com/)