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

[µo°Ý] ¦p¦ó¶Ç¦^¦X±ø¥óªº¤é¤l

[µo°Ý] ¦p¦ó¶Ç¦^¦X±ø¥óªº¤é¤l

¤j®a¦n, ¦³¨S¦³¤èªk¯à±Nªí¤@¦X±ø¥óªº¤é¤l¶Ç¦^ªí¤G, ÁÂÁÂ

rainfall.rar (7.57 KB)

«B¤ôªí

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-8 09:12 ½s¿è

¦^´_ 1# ffff56666
²Å¦XDate of Rainfall > 20mm¥B±Æ°£Àx¦s®æ¤º®e¬°¡uTrace¡v»P¡u-¡v¤§±ø¥ó¡AÀx¦s®æB43¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)
=IFERROR(SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1))&"/"&B$7,"")
¦V¥k¡B¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

ÁÂÁÂp212¦^µª, ¦ý¦bÀx¦s®æB43¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)«á, ¥þ³¡Åã¥Ü¬° #NAME?, ¦P®É¶Ç¦^ªº¤é¤l¯à§_¥H¤é´Á­ÈÅã¥Ü¥H¤è«K§ä¥X¤é¤l¬O§_¬P´Á¤Ñ, ÁÂÁÂ

TOP

­ì¨Ó¤p§Ì¥Îexcel 2003, ©Ò¥H¨S¦³IFERRORªº, ©Ò¥HÅã¥Ü#NAME?, ¦ý¶Ç¦^ªº¼Æ¾Ú¯à§_¥H¤é´Á­ÈÅã¥Ü©O, ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-8 16:15 ½s¿è

¦^´_ 4# ffff56666
1¡Bfor Excel 2007: Àx¦s®æB43¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)
=IFERROR(DATE(B$6,B$7,SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1))),"")
µù¡G±zªº³nÅ骩¥»¤£¬O¼Ð¥ÜOffice 2007¡H
2¡Bfor Excel 2003: Àx¦s®æB43¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)
=IF(ISERROR(DATE(B$6,B$7,SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1)))),"",DATE(B$6,B$7,SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1))))

Àx¦s®æB43®æ¦¡¤§¡u¼Æ­È¡v½Ð³]¬°¡u¤é´Á¡v¡A¦V¥k¡B¦V¤U½Æ»s¡C
½Ð°Ñ¦Ò¡I

TOP

¦¨¥\¤F, ¦hÁÂÀ°¦£!
·Q°Ý°Ý¯à§_¦b¤U«B¤Ñ·í¤¤¦Û°Ê¶Ç¦^¦h¤Ö¤Ñ¬O¬P´Á¤Ñ, ¤Î¦h¤Ö¤Ñ¬O°²´Á©O, ÁÂÁÂ

rainfall2.rar (9.64 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-9 09:18 ½s¿è

¦^´_ 6# ffff56666
1¡B¦^¶Ç²Å¦XRainfall > 20mmÁ`¤Ñ¼Æ(²Ä65¦C)»PRainfall > 20mm¤§¬P´Á¤éÁ`¤Ñ¼Æ(²Ä64¦C)¡G
Àx¦s®æB64=SUMPRODUCT((TEXT(B43:B62,"aaa")="¶g¤é")*1)
Àx¦s®æB65=COUNTIF(B$8:B$38,">20")
¦V¥k½Æ»s¡A½Ð°Ñ¦Ò¡I
2¡B¦Ü©ó²Å¦XRainfall > 20mm±ø¥ó¤§¡u°²´Á¡v­pºâÄÝ¡u¦h¹ï¦h¡v¡A¥»¤H¼ÈµL¸Ñ¡A¦³½Ðª©¥D¡B¶Wª©«ü±Ð¡AÁÂÁ¡I

TOP

ÁÂÁÂp212¥Sªº«ü±Ð,¤p§Ì¤w¸gÀò¯q¨}¦h¤F

TOP

¦^´_ 7# p212


    ¦Ü©ó²Å¦XRainfall > 20mm±ø¥ó¤§¡u°²´Á¡v­pºâÄÝ¡u¦h¹ï¦h¡v¡A
>> Àx¦s®æ B63=SUMPRODUCT(COUNTIF(B$43:B$62,$L$43:$L$59))
¤£ª¾¬O§_¬O³o¼Ëªº»Ý¨D¶Ü?

TOP

¦¨¥\¤F,ÁÂÁÂ
¦ýÁÙ¦³¤@­Ó²×·¥°ÝÃD«Ý¦U¦ì¤j¤j¸Ñµª, ´N¬O¯à§_±Nªí¤Gªº¸ê®Æ¦©°£¤F°²¤é¤Î¬P´Á¤Ñ«á¦^¶Ç¦Üªí¤T©O?

rainfall3.rar (10.71 KB)

ªí¤T

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD