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

[µo°Ý] ¸ê®Æ¨Ì¦Ê¤À¤ñ¤j¤p¦Û°Ê±Æ§Ç¤½¦¡

[µo°Ý] ¸ê®Æ¨Ì¦Ê¤À¤ñ¤j¤p¦Û°Ê±Æ§Ç¤½¦¡


½Ð°Ý¦p¦ó¨Ï¥Î¤½¦¡¡A±NABÄæ¸ê®Æ¥H¦Ê¤½¤ñ¡y¥Ñ¤p¦Ü¤j¡z±Æ§Ç
µ²ªG¦pDEÄæ¡A¥B·íBÄæ¦Ê¤À¤ñÅܰʮɡA¤½¦¡Äæ¸ê®Æ¤]·|¸òµÛÅÜ°Ê

¥H¤W¨D¸Ñ~~~~~~~~~«D±`·PÁÂ!!!!!


´ú¸Õ.rar (7.76 KB)
*¦v¤k¤@ªTµL»~*

¦^´_ 5# ML089

m¤j~~·PÁ§Aªº¦A¦¸À°¦££¬¡I¡I¯u¬O¤j¦n¤H¤@ªT£°
*¦v¤k¤@ªTµL»~*

TOP

¦^´_ 4# msmplay

D1:E20
D1 {=INDEX(A:A,1/MOD(LARGE($B$1:$B$20+1/ROW($B$2:$B$21),ROW(A1)),1)-1)}
¥k©Ô¤U©Ô

ª`·N¡A1/ROW(B1)=1¡A·|¦³°ÝÃD¡A1/ROW($B$1:$B$20) §ï¬° 1/ROW($B$2:$B$21) ©Î 1/ROW($2:$21)


G4:Z5
G4 {=INDEX(1:1,1/MOD(LARGE($G$2:$Z$2+1/COLUMN($G$2:$Z$2),COLUMN(A1)),1))}
¥k©Ô¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

M¤j~~~~~¥i¥H¦A½Ð±Ð©p2­ÓÃþ¦üªº¤½¦¡°ÝÃD¶Ü!?°ÝÃD¦pªþÀÉ~~~~~~¶W¯Å·PÁÂ



´ú¸Õ.rar (9.84 KB)
*¦v¤k¤@ªTµL»~*

TOP

¦^´_ 2# ML089


   M¤j~«D±`·PÁ©pËç¡I¡I°ÝÃD¤w¸Ñ¨M~~~~
*¦v¤k¤@ªTµL»~*

TOP

¦^´_ 1# msmplay


=INDEX(A:A,MOD(SMALL(INT($B$1:$B$20*10^6)*100+ROW($B$1:$B$20),ROW(A1)),100))
¥k©Ô¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD