- ©«¤l
- 49
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 68
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-28
- ³Ì«áµn¿ý
- 2022-6-14
|
¦^´_ 2# Hsieh
¦b¦¹¥ý·PÁÂ¥ý¶iªº«ü¾É
¦³Ãö¥ý¶i©Ò¼gªº¨ç¼Æ~·Q¦b¸ò¥ý¶i½Ð±Ð¤@¤U
K=MATCH(Sheet1!$A2,³æ¦ì,0)+MOD(COLUMN(),2)¤¤ªº
+MOD(COLUMN(),2)
NO=OFFSET(Sheet1!$I$1,1,k,COUNTA(INDEX(Sheet1!$J:$AN,,k))-1,)¤¤ªº
COUNTA(INDEX(Sheet1!$J:$AN,,k))-1,)
³o³¡¤À¥i§_½Ð¥ý¶i«ü¾É»¡©ú¤@¤U~
¥t¥~¦b§Úªºªþ¥óÀɤ¤ªºA1Äæ¦pªG¿ï¾Ü³æ¦ìB
¦bCÄ椤´NµLªkÅã¥Ü¥XB³æ¦ì«OºÞ¤Hªº©m¦W¿ï³æ~·q½Ð¥ý¶i¦A¦¸«ü¾É~ |
|