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

½Ð°Ý±Æ§Ç°ÝÃD

½Ð°Ý±Æ§Ç°ÝÃD

½Ð°Ý±Æ§Ç±Æ°ÝÃD,·Q¥ÎEÄæ¥Ñ¤p±Æ¨ì¤j,
±Æ°£­t¼Æ¤£±Æ,¤S¥i¯à¦³¿ù»~­È
©Ò¥H¥Î¤FCOUNTIF±Æ,¦ý¤£ª¾¦p¦ó
¤~¯à¥Ñ¤p±Æ¨ì¤j,½Ð°Ý¬O§_¦³¦nªº¤èªk,ÁÂÁ ±Æ§Ç°ÝÃD.zip (11 KB)

¦^´_ 1# yan2463

"¸ê®Æ"¸Ìªº"¿z¿ï"¥\¯à¤£¦æ¶Ü? ¥i¥H¿ï¾Ü¥h°£¿ù»~­È¸ò­t¼Æ¡A¦³¦^µª¨ì±zªº°ÝÃD¶Ü?
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¥Ñ¤p¦Ó¤j±Æ§Ç¡H­ì¤½¦¡¦ü¥G¬Û¤Ïªº
=IF(ISERR(1/(E2>0)),"",E2)

TOP

¦^´_ 2# VBALearner

ÁÂÁ§A,§Úªº¸ê®Æ¬OÀH®ÉÅܰʪº,©Ò¥H¥i¯àµLªk¨Ï¥Î¿z¿ïªº¥\¯à

TOP

¦^´_ 3# ­ã´£³¡ªL

ÁÂÁ§A,¥H¤w¥Ñ¤p±Æ¨ì¤j
¦ýÁÙ¦³¨Ç°ÝÃD
1.¦n¹³¨S¦³±q1¶}©l±Æ
2.¦³­«ÂЪº±Æ¦W­È

TOP

¦^´_ 5# yan2463


¬O­n±Æ§Ç? ÁÙ¬O±Æ¦W?
­Y¬O±Æ¦W, ¤£¬O³Ì°ª¤Àªº±Æ²Ä¤@? ¨º§A­ì¨Óªº¤½¦¡´N¨S¿ù¤F!

TOP

¦^´_ 6# ­ã´£³¡ªL

­n±Æ¦W,¦ý¬O­n¥Ñ¤p¨ì¤j±Æ
¹³RANK¥i¥H¥Ñ¤j¨ì¤p,¤]¥i¥Ñ¤p¨ì¤j
§Ú¤§«eªº¤½¦¡,¬O¥Ñ¤j±Æ¨ì¤p,
¤£ª¾¦p¦ó¤~¯à¥Ñ¤p¨ì¤j

TOP

¦^´_ 7# yan2463


¸Õ¸Õ³o¬O§_¬O§Aªº·N«ä¡G¥Ñ¤p¦Ó¤j
=IF(ISERR(0/(E2>0)),"",COUNTIF(E:E,"<"&E2)-COUNTIF(E:E,"<0")+1)

TOP

¦^´_ 8# ­ã´£³¡ªL
¯uªº¤ÓÁÂÁ¤F,´ú¸Õok

TOP

¦^´_ 8# ­ã´£³¡ªL

¤£¦n·N«ä,¤§«e¦³½Ð±Ð§A±Æ¦W°ÝÃD,
²{¦b¹J¨ì­Y¦³#N/A,¤]¤£·Q±Æ¦W
¤£ª¾¤½¦¡»Ý¦p¦ó­×§ï,¤£ª¾¬O§_¥i¥HÀ°¦£
ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD