ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó±qºô­¶¤U¸ü¸ê®Æ¦Û°ÊÂà´«¦¨©Ò»Ý­n¸ê®Æ

B2°}¦C¤½¦¡
=INDEX(CHAR(ROW($65:$73)),MATCH(INDEX($Y:$Y,B1+1),TEXT(ROW($A$1:$A$9),"[DBNum1][$-404]G/³q¥Î®æ¦¡"),0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 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°Ý

TOP

B2=IF(INDEX($Y:$Y,COLUMN())="¿é","L",IF(INDEX($Y:$Y,COLUMN())="Ĺ","W",""))
¦V¥k½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

=LEFT(INDEX($Y:$Y,MATCH(B1,$W:$W,0),),1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD