¦p¦ó±qºô¶¤U¸ü¸ê®Æ¦Û°ÊÂà´«¦¨©Ò»Ýn¸ê®Æ
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office 2011
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-6-23
- ³Ì«áµn¿ý
- 2011-6-28
|
¦p¦ó±qºô¶¤U¸ü¸ê®Æ¦Û°ÊÂà´«¦¨©Ò»Ýn¸ê®Æ
¥»©«³Ì«á¥Ñ asky2346 ©ó 2011-6-24 15:22 ½s¿è
¦U¦ì¦n
¤p§Ì³Ìªñ¤~±µÄ²EXCEL µo²{¦³«Ü¦hªF¦è³£¤£·|¥Î
±æ¦U¦ì¯à«ü±Ð¤@¤U¤p§Ì
¬õ°é¤¤¬O±qºô¶¤U¸ü¸ê®Æ
§Ú·Q§âY¦Cªº¤¤¥æ¦r §Y¤@¤G¤T ¦Û°ÊÂà´«¦¨ B2,C3µ¥ªº^¤å¦r¥i¥H¶Ü
ÁÙ¦³¤@Ó°ÝÃD ±qºô¶±o¨Óªº¸ê®Æ ·|¦Û°Ê§â³Ì·sªº¸ê®Æ©ñ¨ì³Ì³»
³o¼Ë¦³¤°»ò¤èªk¥i¥H§â·s±o¨Óªº¸ê®Æ ¦Û°ÊÂà¤J¨ì¹ïÀ³ªº®æ¼Æ¤¤
½Ð¦U¦ì¦h¦hÀ°¦£ |
|
|
|
|
|
|
- ©«¤l
- 65
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 83
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-4
- ³Ì«áµn¿ý
- 2012-5-21
|
¬O®Ú¾Ú¤°»òªº±ø¥ó©ñ¶i¥hªº©O?¦Ó"A,B,C"¤S¥Nªí¤°»ò·N«ä©O? |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office 2011
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-6-23
- ³Ì«áµn¿ý
- 2011-6-28
|
"¤@" = "A"
"¤G" = "B"
"¤T" = "C"
¥H¤WA,B,C ¸ò¤@,¤G,¤T ¥u¬O¨Ò¤l |
|
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office 2011
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-6-23
- ³Ì«áµn¿ý
- 2011-6-28
|
º¥ýÁÂÁÂHsieh¤j¤jªº¦^ÂÐ
§Ú«ö§Aªº°µªk¦bB2¿é¤J¤F¬ÛÃöªº¤½¦¡«á
ª½±µ¿é¤J¥X²{¤F¥H¤U±¡ªp
¥[¤F¤¤¬A¸¹«á¥X±¤F#N/A
ÁÙ¦³·Q°Ýªº¬O³o¥y[DBNum1][$-404]G/³q¥Î®æ¦¡"),0))¤j·§¬O¤°»ò·N«ä
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 257
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-27
|
¦^´_ 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°Ý
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office 2011
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-6-23
- ³Ì«áµn¿ý
- 2011-6-28
|
ÁÙ¦³ÂI°ÝÃD °²¦p§Ú¤U¸üªº¸ê®Æ¤£¬O"¤@","¤G","¤T" ¦Ó¬O¨ä¥L¤¤¤å¦r
¥i¥H¹ïÀ³¨ì¬ÛÃöªº^¤å¦r¶Ü
¨Ò¦p¦bY¦Cªº¬O"¿é","¾Æ" ¥i¥H¹ïÀ³"W"©M"L"ªº¶Ü |
|
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office 2011
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-6-23
- ³Ì«áµn¿ý
- 2011-6-28
|
¦^´_ 8# Hsieh
ÁÂÁ¤j¤j¸Ñ¨M¤F§Úªº°ÝÃD
¥i¬O§ÚÁÙ¹J¨ìÂI§xÃø¤£·|¸Ñ¨M
¥i¥H§â¸ê®Æ¹ïÀ³¨ì¬ÛÃöªº®æ¼Æ¶Ü
¦p¤U¹Ï
B1,C1,D.....1 ¸òW8,W7,W6....ªº¼ÆȬO¤@¼Ë®É
¤~¹B¦æ§A¦b¤W±©Ò»¡ªººâ¦¡ ¥i¥H¶Ü
|
|
|
|
|
|
|