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

[µo°Ý] ½Ð°Ý¤ñÁÉ ³Ó²v

[µo°Ý] ½Ð°Ý¤ñÁÉ ³Ó²v

½Ð°Ý§Ú­n°µ¤@¦Û°Ê§P©w³Ó²vªºªí!
¨Ò¦p:¤ñÁÉ5¤H!¤À¼Æ¬°:
²Ä¤@­Ó±o¤À 6¤À
²Ä¤G­Ó±o¤À 9¤À
²Ä¤T­Ó±o¤À 8¤À
²Ä¥|­Ó±o¤À 7¤À
²Ä¤­­Ó±o¤À 8¤À
µ²ªG:
²Ä¤@­Ó³Ó²v¬°-4
²Ä¤G­Ó³Ó²v¬°4
²Ä¤T­Ó³Ó²v¬°1
²Ä¥|­Ó³Ó²v¬°-2
²Ä¤­­Ó³Ó²v¬°1
³o¼Ë­n«ç»ò°µ¥X³o®æ¦Û°Ê§P©w³Ó²v!
·PÁÂ!

¦^´_ 1# wuchanchen


    ½Ð°Ý¤@¤U§PÂ_ªº¨Ì¾Ú¬°¦ó¡H

TOP

¦^´_ 2# owen06
§PÂ_¨Ì¾Ú­n¦Û¦æ¿é¤J±o¤À¤À¼Æ:
±o¤À°ª¥[1¤À!
±o¤À§C¦©1¤À!
¥­¤â¤£¥[¤£´î!
5­Ó¤H¤ñÁɪº¸ÜĹ2­Ó¿é2­Ó=0
Ĺ1­Ó¿é3­Ó=-2
Ĺ1­Ó¿é2­Ó,¥­¤â1­Ó=-1
--------------------------------------------------------------------
µ¥©ó¬O«OÄÖ²y5­Ó¤H¤ñÁÉ
²Ä¤@¤H220¤À
²Ä¤G¤H210¤À
²Ä¤T¤H220¤À
²Ä¥|¤H200¤À
²Ä¤­¤H230¤À
¶ñ¤J¤À¼Æ«á,«á­±¤@Äæ­nÅý¥L¦Û°Ê§P©w³Ó²v´X³õ!
²Ä¤@¤H220¤À(+2,-1¥­¤â1)µ²ªG­nÅý¥L¦Û°Ê§P©w¬°1
²Ä¤G¤H210¤À(-3,+1)µ²ªG­nÅý¥L¦Û°Ê§P©w¬°-2
²Ä¤T¤H220¤À(+2,-1¥­¤â1)µ²ªG­nÅý¥L¦Û°Ê§P©w¬°1
²Ä¥|¤H200¤À(-4)µ²ªG­nÅý¥L¦Û°Ê§P©w¬°-4
²Ä¤­¤H230¤À(+4)µ²ªG­nÅý¥L¦Û°Ê§P©w¬°4
ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ owen06 ©ó 2015-8-27 17:11 ½s¿è

¦^´_ 3# wuchanchen


    ³o¼Ë¹ï¶Ü¡H
    =COUNTIF($A$1:$A$5,"<"&A1)-COUNTIF($A$1:$A$5,">"&A1)
    ¤½¦¡¦V¤U©Ô½Æ»s

TOP

¦^´_ 4# owen06


«D±`·PÁÂ!¥i¥H¤F!
¦A½Ð±Ð¤@¤U!
¦pªG¬O¥´5§½,5§½¦Û°Ê¥[Á`¤À¤]­nºâ¤@¦¸!
¦P¼Ë½Æ»s¤½¦¡ªº¸Ü¥L·|³s0¤Àªº¤]ºâ¤U¥h(ªí®æ¹w³]25¤H,¹ê»Ú°ÑÁÉ5¤H)!
½Ð°Ý¥i¥H0¤Àªº¤£¦C¤J­pºâ¶Ü?
·PÁÂ!

TOP

¥»©«³Ì«á¥Ñ owen06 ©ó 2015-8-27 18:51 ½s¿è

¦^´_ 5# wuchanchen


    ¥i¥H§Ë­Ó²©öªºªþÀɨӶܡH³o¼Ë¨ä¥L°ª¤â­nÀ°§A¤]·|¤è«K¨Ç¡C

TOP

¦^´_ 5# wuchanchen

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# wuchanchen

0¤À ¸ò ¨S¦³°ÑÁɬO¦³®t§Oªº
½Ð°Ý§A­n¦p¦ó°Ï§O 0¤À ¸ò ¨S¦³°ÑÁÉ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# owen06
·PÁ¦U¦ìªº¦^´_!

   
Nªº³o¤@±Æ,¥L¦n¹³³sN9~N27³£ºâ¤U¥h!
­n«ç¼ËÅý¥L¥u¨Ì°ÑÁɤH¼Æ­pºâ?
·PÁÂ!

TOP

¦^´_ 9# wuchanchen

¨Ï¥Î COUNTIFS ¦b¥[¤@­Ó§PÂ_ "<>0" ´N¥i¥H
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD