gong

aÄæ©m¦Wa001-a100
b1=rand()¤U©Ô¦Üb100
c1=rank(b1,b1:b100)
ÀY¼ú1¦W=index(a1:a100,match(1,c1:c100,0))
¶L¼ú2¦W=index(a1:a100,match(2,c1:c100,0)),index(a1:a100,match(3,c1:c100,0))
°Ñ¼ú3¦W
´¶¼ú10¦W
°Ñ¼ú¥H¤UÃþ±À

gong

¦pªG­n¤£¦P¤H¦³¤£¦P©â¼ú¾÷·|,¦p¦~¸ê¨Cº¡¤@¦~¼W¥[¤@¦¸©â¼ú¾÷·|
§Ú¤ä«ù8¼Óivanyung
ªº°µªk

¨ì©³¬O¤â¤u°µÁÙ¬O¨ç¼Æ§@¨º­n¬Ý§Aªº»Ý¨D
¥Î¨ç¼ÆÁٻᦳ¬D¾Ô©Êªº
§Ú¤£ª¾¬O§_·|°µ,­n·Q·Q¬Ý,¥ý³o¼Ë¦³»Ý¨D¦A»¡

gong

§Ú»¡ªº¥u¬O¥Ü¨Ò,»P§AªºÀɮצì¸m¤£²Å

­n¬Û¦P¦ì¸m,¤W¶ÇÀɮקa,µLªkÀ°§A«Ø¸ê®Æ

gong

¤½¦¡2!
E2=IF(RANK($A2,$A$2:$A$56)=1,"ÀY¼ú",IF(RANK($A2,$A$2:$A$56)<=3,"¶L¼ú",IF(RANK($A2,$A$2:$A$56)<=6,"°Ñ¼ú",IF(RANK($A2,$A$2:$A$56)<=16,"´¶¼ú",""))))
¤U©Ô

gong

¥t¸Ñ
¤½¦¡2!
H2=INDEX($B$2:$C$56,MATCH($F2,$D$2:$D$56,0),1)
I2=INDEX($B$2:$C$56,MATCH($F2,$D$2:$D$56,0),2)

gong

®i¶}¦¡
¤½¦¡1!
F2
{=IF((ROW()-1)<=SUM($D$2:$D$24),INDEX($C$2:$C$24,MATCH(1,--(COUNTIF(F$1:F1,$C$2:$C$24)<$D$2:$D$24),0)),"")}

G2=IF(F2="","",RAND())

H2=IF(F2="","",IF(RANK($G2,$G$2:$G$56)=1,"ÀY¼ú",IF(RANK($G2,$G$2:$G$56)<=3,"¶L¼ú",IF(RANK($G2,$G$2:$G$56)<=6,"°Ñ¼ú",IF(RANK($G2,$G$2:$G$56)<=16,"´¶¼ú","")))))

gong

½Ð°Ý¤@¤U®@¡A§Ú¤§«e¤]¬O¥Î¶Ã¼Æªº¤è¦¡¨M©w¤¤¼ú¦W³æ¡A
µ²ªGµo²{¶Ã¼Æ¨ç¼Æ§@¥Xªºµ²ªG·|­«½Æ­C¡A
­è¤~¸Õ¤]·|³o ...
kittylin123 µoªí©ó 2010-12-9 12:40

a1:a100=rand()
b1:b100=rank(a1,$a$1:$a$100)
bÄæ§Y¬°1:100¤£­«ÂЪº¶Ã¼Æ