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

RANK /COUNTIF¦³»~

RANK /COUNTIF¦³»~

¦U¦ì¦n,

§Ú¦b§ËRANK ±Æ¦W®É, ¸ê®Æ¥u¯à³]¨ì235­Ó, ¦A¨Ó´N¿ù»~¤F,  ¦]¬°§Úªº¸ê®Æ³£¬O¹L¥aªº.. ¦³¿ìªk¸Ñ¨M¶Ü?
RANK ¦³»~.JPG
2012-6-7 14:11



«á¨Ó§Ú¬Ý¦³¤H±Ð¾Ç¥i¥HCOUNTIF, ¦ý¶]¥X¨Ó¬O¿ù»~ªº, ¦³¤G­Ó1, ©Î¤G­Ó1¤§Ãþªº,  §Ú¸Ó«ç»ò¸Ñ¨M©O, ½Ð¦U¦ìÀ°À°¦£! ·PÁÂ
COUNTIF ¦³»~.JPG
2012-6-7 14:11

rankÀ³µL¦¹­­¨î10000µ§¤]¥i¥Î¡C
countif¦b¤¤°ê¦¡±Æ¦W¤~·|¥Î¨ì¡C
rank¥i¥Îsumproduct´À¥N
=SUMPRODUCT(($A$1:$A$1000>A1)*1)+1

TOP

¦^´_ 2# ANGELA

«D±`ÁÂÁ±zªº¨ó§U, ¦ý¤´µM¶]¤£¥X¨Ó, ½Ð°Ý¬O§Ú­þ¸Ì¦³§Ë¿ù¶Ü?   ¦A½Ð±z¦hÀ°¦£, ·P¿E¤£ºÉ!
   
SUMPRODUCT ¿ù»~.JPG
2012-6-7 15:39

TOP

¤W¶ÇÀɮסA§_«h´N¹³½M¤lºN¶H¡C

TOP

¦^´_ 4# ANGELA


    ±Æ¦W.rar (38.51 KB)

¦A³Â·Ð±z¤F!

TOP

B1020,B1805ªº­È¬O#VALUE!

TOP

¦^´_ 6# ANGELA

¯u©êºp! ¨S¦³¬Ý¨ì³o­Ó¿ù»~,  ¤£¹L³o¼Ë¦n¹³¤]¶]¤£¥X¨Ó, ¦A½Ð¨ó§U1
    ±Æ¦W.rar (38.59 KB)

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-6-7 17:10 ½s¿è

¦^´_ 7# yc1031

C2=IF(A2="NO","",SUMPRODUCT(($A$2:$A$3000="YES")*($B$2:$B$3000>B2))+1)

TOP

¦^´_ 8# register313


    ¦¨¥\¤F, ·PÁÂ!  ¤£¹L¬O§_¦³¿ìªk¸Ñ¨M, ±Æ¦Wªº°ÝÃD, ¹³²Ä1ªº¦³¤­­Óªº¸Ü, ¨º¦A¨Óªº±Æ¦W·|¬O6, 2.3.4.5 ·|¤£¨£, ³o­Ó¦³¿ìªk¸Ñ¨M¶Ü?  ÁÂÁÂ!

TOP

¦^´_ 9# yc1031

±Æ¦W¥»¨Ó´N¬O³o¼Ëªº
²Ä1¦W¦³5­Ó,¦A¨Ó´N¬O²Ä6¦W

¦p¦³¨ä¥L±Æ§Çªº»Ý¨D,½Ð¤W¶ÇexcelÀÉ®×Á|¨Ò»¡©ú¦p¦ó±Æ§Ç

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD