¥»©«³Ì«á¥Ñ mycmyc ©ó 2010-10-14 18:39 ½s¿è
½Ð°Ý
a15 99101501
a16 99101502
a17 99101503
a18 99101601
¤W¦³ 3µ§991015¬Û¦P COUNTIF(A15:A18,99101501) Ȭ°1 COUNTIF(A15:A18,991015) ÅÜ0
¦ý§Ún·j´M Ȭ° 991015 À³¸Ó¦³¤Tµ§ ¥Î COUNTIF(LEFT(A15,6): LEFT(A18,6),991015) ¤£¦æ
«ç»ò°µ¤ñ¸û¦n©O
§Ú¬O·Q¥Î¤é´Á§@½s¸¹ ¤S¤£Åý¥L«½Æ
·PÁ¤j®a«ü¾É ²×©ó§¹¦¨
99101500 99/10/15
99101600 99/10/16
99101501 99/10/15
99101502 99/10/15
99101503 99/10/15
99101504 99/10/15
¤½¦¡ =IF(B19="","",IF(COUNTIF(A14:A18,LEFT(TEXT(B19,"ee/mm/dd"),2)&MID(TEXT(B19,"ee/mm/dd"),4,2)&MID(TEXT(B19,"ee/mm/dd"),7,2)&"*")>0,TEXT(VALUE(LEFT(TEXT(B19,"ee/mm/dd"),2)&MID(TEXT(B19,"ee/mm/dd"),4,2)&MID(TEXT(B19,"ee/mm/dd"),7,2)&"00")+COUNTIF(A14:A18,LEFT(TEXT(B19,"ee/mm/dd"),2)&MID(TEXT(B19,"ee/mm/dd"),4,2)&MID(TEXT(B19,"ee/mm/dd"),7,2)&"*"),"0"),LEFT(TEXT(B19,"ee/mm/dd"),2)&MID(TEXT(B19,"ee/mm/dd"),4,2)&MID(TEXT(B19,"ee/mm/dd"),7,2)&"00"))
¦ý COUNTIF(A14:A18,xxxxx) ¹J¨ì°ÝÃD §Ú¥Î COUNTIF ·j´M »Ý¦Û a14¨ì¥Ø«e¿é¤JÀxÂÃ®æ ¼g¦n ½Æ»s ¶K¤W A14 ·|ÅÜ°Ê
¦³¿ìªk §â COUNTIF(A14:A18,xxxxx) A14 ©T©w¶Ü
¤½¦¡¦nªø ¤gªk·Ò¿û ¦³¿ìªk§â¤½¦¡ºë²¶Ü ÁÂÁ |