- ©«¤l
- 70
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 83
- ÂI¦W
- 27
- §@·~¨t²Î
- win
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2024-2-3
- ³Ì«áµn¿ý
- 2024-4-13
|
¦^´_ 17# Andy2483
½Ð°Ý¤@¤U§ÚÀx¦s®æA18¦V¤U±a¤J¶W³sµ²Àx¦s¤½¦¡vba¦p¦ó¼g
=IF(D18="","",HYPERLINK("#"&LOOKUP(1,0/COUNTIF(INDIRECT({"POWER¸Õ²£";"«Ý³ø¼o";"³ø¼o";"1¦Ü588";"SUPER";"POWER"}&"!B:B"),D18),{"POWER¸Õ²£";"«Ý³ø¼o";"³ø¼o";"1¦Ü588";"SUPER";"POWER"})&"!"&"B"&MATCH(D18,INDIRECT(LOOKUP(1,0/COUNTIF(INDIRECT({"POWER¸Õ²£";"«Ý³ø¼o";"³ø¼o";"1¦Ü588";"SUPER";"POWER"}&"!B:B"),D18),{"POWER¸Õ²£";"«Ý³ø¼o";"³ø¼o";"1¦Ü588";"SUPER";"POWER"})&"!"&"B:B"),0),"¡´")) |
|