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

[µo°Ý] ¦³Ãöªí®æ¼Æ¦r¹ïÀ³¤å¦r(¦nÃø~¨D¯«¤H!!)«æ~ÁÂÁÂ

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-10 08:42 ½s¿è

¦^´_ 1# qq910057
F2=SMALL(B2:E2,1)
G2=INDEX($B$1:$E$1,,SMALL(B2:E2,1))
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 1# qq910057
Sorry!
­×¥¿G2=INDEX($B$1:$E$1,,MATCH(SMALL(B2:E2,1),B2:E2,0))

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD