ªð¦^¦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 : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD