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

±Æ§Çªº°ÝÃD

±Æ§Çªº°ÝÃD

¦pªþ¥ó Book2.zip (1.8 KB)
§Ú¨Ï¥Îlarge¥h§ì²Ä¤@¡B¤G¦W
­è¦n²Ä¤@¡B¤G¼Æ¦r¬Û¦P
¶ð°t«K¥Îindex®É·|§ì¥X¬Û¦Pªº¦r
¥i¬O§Ú§Æ±æ¥L²Ä¤@¦W§ìB
²Ä¤G¦W§ìI
»Ý­n¦A¥[¤J¤°»ò§PÂ_?

¥[»²§UÄæ ±Æ§Ç.rar (2.04 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥[¸É§UÄæ¬O¸û¥¿²Îªº§@ªk,¦¹¨Ò¤]¥i¥Î
=LOOKUP(2,1/(MAX(B1:B26)=B1:B26),A1:A26)
¥i§ì¨ì³Ì«á¤@­Ó³Ì¤j¼Æ

TOP

¦^´_ 1# vvcvc


¤£¥Î»²§U¦C
°}¦C¤½¦¡ C1
=INDEX($A$1:$A$26,MATCH(LARGE(($B$1:$B$26)-ROW($B$1:$B$26)*0.00001,ROW()),($B$1:$B$26)-ROW($B$1:$B$26)*0.00001,0))
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_  vvcvc


¤£¥Î»²§U¦C
°}¦C¤½¦¡ C1
=INDEX($A$1A$26,MATCH(LARGE(($B$1B$26)-ROW($B$1B$26 ...
asimov µoªí©ó 2010-9-29 23:31


¤£¦n·N«ä¦A½Ð±Ð¤@¤U
³o­Ó¤½¦¡©ñ¦bC1µ²ªG¬O¥¿½Tªº
¦ý©ñ¨ìB29«o¤£¦æ
³o¬O¤°»ò½t¬G?

TOP

¦^´_ 5# vvcvc


¦]¬°
=INDEX($A$1:$A$26,MATCH(LARGE(($B$1:$B$26)-ROW($B$1:$B$26)*0.00001,ROW()),($B$1:$B$26)-ROW($B$1:$B$26)*0.00001,0))
·í¤½¦¡²¾¨ìB29®ÉROW()=29,LARGE¨ÃµL²Ä29¶¶¦ì,©Ò¥HµLªk±o¨ì¥¿½Tµ²ªG
±N¤½¦¡¤p§ï¤@¤U§Y¥i
B29
=INDEX($A$1:$A$26,MATCH(LARGE(($B$1:$B$26)-ROW($B$1:$B$26)*0.00001,ROW(A1)),($B$1:$B$26)-ROW($B$1:$B$26)*0.00001,0))
¬Ý¨ì®t§O¤F¶Ü
ROW()§ï¦¨¤FROW(A1)
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¥»©«³Ì«á¥Ñ vvcvc ©ó 2010-10-6 13:58 ½s¿è

¸Õ¹L¥i¥H¨Ï¥Î
¯à§_¦A½Ð±Ð($B$1:$B$26)-ROW($B$1:$B$26)*0.00001³o­Ó­pºâ¦¡ªº¥Î·N¬O¤°»ò?
§Ú«öF9¬Ý¨ìªº¬O±NB1:B26¥þ³¡´î0.00001
³o­Ó½d³ò¤ºªºarray¨ÌµM¬O¦³¬Û¦P¤j¤pªº¼Æ­È
¬°¤°»ò¥i¥H°µ¥X§Ú´Á±æªº®ÄªG?

§Ú¨Ï¥Î³o¤½¦¡, §â­pºâ¨ú®ø
´N¤S¦^¨ì§Ú­ì¥»ªºª¬ªp
¼Ò¥é¤½¦¡§Ú¤w¸g¥i¥H¦b§Ú»Ý­nªº¦a¤è¹B¥Î, ¥u¬O¤£©ú¥Õ³o¤½¦¡ªº­ì²z
¥i§_¦A³Â·Ð±z¸ÑÄÀ?

TOP

¸Õ¹L¥i¥H¨Ï¥Î
¯à§_¦A½Ð±Ð($B$1B$26)-ROW($B$1B$26)*0.00001³o­Ó­pºâ¦¡ªº¥Î·N¬O¤°»ò?
§Ú«öF9¬Ý¨ìªº¬O±N ...
vvcvc µoªí©ó 2010-10-6 13:55



    §Ú«öF9¬Ý¨ìªº¬O±NB1:B26¥þ³¡´î0.00001
³o¥y¦³°ÝÃD,À³¸Ó¬O²Ä¤@¦C-0.00001,²Ä¤G¦C-0.00002,²Ä¤T¦C-0.00003..........

TOP

¦^´_ 7# vvcvc


($B$1:$B$26)-ROW($B$1:$B$26)*0.00001³o­Ó­pºâ¦¡ªº¥Î·N
Á|¨Ò»¡©ú
B2»PB9ªº­È³£¬O8,¨Ï¥Î¤½¦¡¥u·|±o¨ìB2ªº8
©Ò¥H±NBÄ檺­È-ROW($B$1:$B$26)*0.00001

ROW($B$1:$B$26)*0.00001­pºâµ²ªG¬O0.00001,0.00002,0.00003¨Ì¦¹Ãþ±À
¦]¦¹B2­È8¸g­pºâ«á¬°7.99998     (8-0.00002)
B9­È8­pºâ«á¬°7.99991
¦A¥ÎLARGE¨ú±o¤j¤p±Æ¦C¼Æ
....
¨ä¥L½Ð°Ñ¦Ò¦U¨ç¼Æ»¡©ú
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¤£¦n·N«ä, ¥u¬Ý¨ì¤@°ï¼Æ¦r¨S¬Ý²M·¡
ÁÂÁÂasimov ¤£§[½ç±Ð

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD