¦p¦ó±qºô¶¤U¸ü¸ê®Æ¦Û°ÊÂà´«¦¨©Ò»Ýn¸ê®Æ
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 107
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2025-5-4
               
|
¦^´_ 5# asky2346
1. ¥H°}¦C¤½¦¡¿é¤Jªkctrl+shift+enter§¹¦¨¿é¤J
2. YÄæ¸ê®Æ¥²¶·¬O°ê¦r¤j¼g¼Æ¦r¤~¦æ
=INDEX(CHAR(ROW($65:$73)),MATCH(INDEX($Y:$Y,B1+1),TEXT(ROW($A$1:$A$9),"[DBNum1][$-404]G/³q¥Î®æ¦¡"),0))
ROW($A$1:$A$9)
±N¶Ç¦^1,2,3,....9³o¤EӼƦrªº¼Æ¦C
TEXT(ROW($A$1:$A$9),"[DBNum1][$-404]G/³q¥Î®æ¦¡")
¥ÎTEXT¨ç¼Æ±N1~9³o¨Ç¼Æ¦rÂন°ê¦r
INDEX($Y:$Y,B1+1)
°Ñ·Ó¨ìYÄæªº²Ä?¦C¦ì¸m¡AB1+1=2¡A©Ò¥H·|±o¨ìY2ªº¤º®e
MATCH(INDEX($Y:$Y,B1+1),TEXT(ROW($A$1:$A$9),"[DBNum1][$-404]G/³q¥Î®æ¦¡"),0)
¶Ç¦^¦b°ê¦r¼Æ¦C¤¤§ä¨ìY2ªº¦ì¸m¡A¦p:¤@´N·|¶Ç¦^1¡A¤G´N¶Ç¦^2
CHAR(ROW($65:$73))
±o¨ì65~73³o¨Ç¦r¤¸½Xªº¹ïÀ³^¤å¦r¥À
³Ì«á¥ÑINDEX§ä¨ì^¤å»P°ê¼Æ¦rªº¹ïÀ³ |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|