RANK /COUNTIF¦³»~

yc1031

¦U¦ì¦n,

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

¤U¸ü (130.04 KB)

2012-6-7 14:11

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

¤U¸ü (131.39 KB)

2012-6-7 14:11

ML089

¦^´_ 3# yc1031

¤½¦¡¦³ÂI¤p¿ù»~
­ì¦¡
=IF(A1393="YES",SUMPRODUCT(($B$2:$B$3000>A1393)*1)+1,"")
§ï¬°
=IF(A1393="YES",SUMPRODUCT(($B$2:$B$3000>B1393)*1)+1,"")
´N¬O A1393§ï¬°B1393

yc1031

¦^´_ 12# ANGELA


    ¯uªº«D±`·PÁ±z¤£¹½¨ä·Ðªº±Ð¾É!    °ÝÃD¤w¸g¶¶§Q¸Ñ¨M¤F :D

ANGELA

C2=IF(A2="YES",SUMPRODUCT(($A$2:$A$3000="YES")*($B$2:$B$3000>B2))+SUMPRODUCT(($A$2:A2="YES")*($B$2:B2=B2)),"")
F2=LOOKUP(2,1/($C$2:$C$3000=E2),$B$2:$B$3000)

Hsieh

¦^´_ 9# yc1031

E2=RANK(B2,$B$2:$B$2042,1)+COUNTIF($B$1:B1,B2)

register313

¦^´_ 9# yc1031

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

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

yc1031

¦^´_ 8# register313


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

register313

¦^´_ 7# yc1031

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

yc1031

¦^´_ 6# ANGELA

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

¤U¸ü¦¸¼Æ: 7

2012-6-7 16:19

ANGELA

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