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

excel¬O§_¥i¥H¦³ÀH¾÷©â¼úªº¥\¯à

¦^´_ 9# gong


   
±z¦n¡A·Ó¥»«Å¬ìªºµ²ªGµo²{¡A·|¦³¡u#N/A¡v­Èªº²£¥Í¡A
½Ð°Ý·|²£¥Í³o­Ó°ÝÃD¬O§Ú¨S¦³¨Ï¥Î¦n¡AÁÙ¬O¬O­n¦A±Æ°£ªº°ÝÃD©O?

TOP

¥»©«³Ì«á¥Ñ emma ©ó 2010-8-4 15:34 ½s¿è
¦pªG­n¤£¦P¤H¦³¤£¦P©â¼ú¾÷·|,¦p¦~¸ê¨Cº¡¤@¦~¼W¥[¤@¦¸©â¼ú¾÷·|
§Ú¤ä«ù8¼Óivanyung
ªº°µªk

¨ì©³¬O¤â¤u°µ ...
gong µoªí©ó 2010-8-3 23:03



¨ä¹ê§Ú¤]¦³·Q¹L­n¤â¤u°µ¡A¦ý¦pªG¥i¥H¥Î¨ç¼Æ¥N¥Xªº¸Ü¡A
·íµM§ó¨Î¡A¥u¤£¹L§Ú¤]¤£ª¾¹D¦³¨S¦³¥i¦æªº¿ìªk¡A
©Ò¥H¤~·Q½Ð±Ð¦U¦ì¥ý¶i­Ì¡A
¦]¬°§Ú»Ý­nÀ³¥Îªº¦a¤è¤ñ¸û½ÆÂø¡A
¦pªG¥Î¤â¤uªº¸Ü¥i¯à¤ñ¸û®e©ö¥X¿ù¡A
©Ò¥H¦pªG¦³¨ç¼Æ©Î¤½¦¡¥i®M¥Xªº¸Ü¡A¬O¦A¦n¤£¹L¤F¡A
¤§©Ò¥H³]¤£¦Pªº¤¤¼ú¾÷·|ªº·Qªk¬O¡A
¨Ò¦p®ø¶Oª÷ÃBº¡500¤¸´N¥i±o¤@±iºN±m¨é¡A
a¦pªGÁʶRª÷ÃB¬°10000¡A¨º´N¦³200±iºN±m¨é¡A
¦pªG¨Ì8¼Óivanyung ¤j¤jªº°µªk¡A
¨º»ò§Ú´N±o½Æ»saªº¸ê®Æ200µ§¡A¥H¦¹Ãþ±À¡A
§Ú·Q¡A¦pªG¦³¨ä¥L¤è¦¡¥i¥H¨Ï¥Î´N¦A¦n¤£¹L¤F¡A
QQ

TOP

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

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

TOP

¦^´_ 13# gong


    ±z¦n¡A¤wªþ¤Wªþ¥ó¡AÁÂÁ±z~~

ÀH¾÷©â¼ú´ú¸Õ.rar (6.08 KB)

TOP

¦^´_ 14# emma
DÄ椽¦¡ ­n¥[¤Wµ´¹ï¦ì¸m¤U©Ô  =RANK(A2,A$2:A$56)
§_«h  ©Ô¨ìD56®É ¤½¦¡Åܦ¨    =RANK(A56,A56:A110)
½d³ò¤£¤@¼Ë ¤~·|²£¥Í #N/A

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-4 16:46 ½s¿è

¦^´_ 14# emma


   



   

TOP

¤½¦¡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©Ô
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-8-4 17:52 ½s¿è

¥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.rar (6.52 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

®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.rar (8.29 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ asimov ©ó 2010-8-6 02:14 ½s¿è

¦^´_ 14# emma


´£¨Ñ¥t¤@ºØ¤è¦¡
¨C¦¸¥u©â¥X¤@­Ó¤¤¼ú¤H (I5Äæ¦ì)
±N¤¤¼ú¤H¨Ì§Ç¶ñ¤JF17,F16,F15
¶ñ¤JF17«öenter«á¦b²£¥Í¤U¤@­Ó¤¤¼ú¤H
¶Ã¼Æ²£¥ÍªºID¤£·|­«ÂÐ
·íµM¥²¶·­É§U»²§UÄæ
ÀH¾÷©â¼ú´ú¸Õ(¤£­«½Æ).zip (4.92 KB)


¤w§ó¥¿¶Ã¼Æ¤½¦¡
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD