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

[µo°Ý] if¨ç¼Æ(°}¦C§Î¦¡)¦p¦ó¤@¦¸§P§O¦h­Ó±ø¥ó¡H

[µo°Ý] if¨ç¼Æ(°}¦C§Î¦¡)¦p¦ó¤@¦¸§P§O¦h­Ó±ø¥ó¡H

§Ú¥¿¦b¸Õ¹Ï¥H¤½¦¡¨Ó³B²z§Ú­Ì¤½¥qªº·|­p±b¡A¥Ø«e¹J¨ì¤@­Ó°ÝÃD¡G

Á`¤ÀÃþ±b´ú¸Õ³o­Ó¤u§@ªíªº¶µ¥Ø¦p¤U¡G
AÄæ    BÄæ   
¤é´Á  ¬ì¥Ø

¥Ø«e³o­Ó¤u§@ªí¡A§Ú¼g¤F¥H¤U³o­Ó¤½¦¡¡A¬O­n¥Î¦b¤Uªí¤¤ªºBÄæ
¬ì¥Ø¡GÁʸm¶O
AÄæ    BÄæ    CÄæ    DÄæ    EÄæ
¤ë       ¤é      ¬ì¥Ø   ©ú²Ó   ª÷ÃB

³o­Ó¤u§@ªí¤¤ªºB2·|¿é¤J§Æ±æªº¤ë¥÷¡A¥Øªº¬O­n¦C¥X©Ò¦³ªº¡u¬Y­Ó¤ëªº¬Y­Ó¬ì¥Ø¡vªº¤é´Á
{=IFERROR(DAY(INDEX(Á`¤ÀÃþ±b´ú¸Õ!A:A,SMALL(IF(IFERROR(MONTH(Á`¤ÀÃþ±b´ú¸Õ!$A$1:$A$9999),"")=$B$2,IF(Á`¤ÀÃþ±b´ú¸Õ!$B$1:$B$9999="Áʸm¶O",ROW(¤é°O±b!$A$1:$A$9999),""),""),ROW(A1)))),"")}
¹B§@°_¨Ó³£¨S¦³°ÝÃD
²{¦bµo¥Íªº°ÝÃD¬O¡G¦]¬°§Ú»Ý­n¦bexcel 2003¨Ï¥Î³o­Ó¤å¥ó¡A¦ý¬Oexcel 2003¨S¦³iferror³o­Ó¤½¦¡¡A¦]¦¹»Ý­n§ï¼g¦¨if(iserror(),"",...)ªº«¬¦¡¡A¦ý¬O³o¼Ë§ïªº¸Ü·|Åܱo¤Ó¦h¼h¡AexcelµLªk±µ¨ü
¦]¦¹§Ú§Æ±æ±N¤ë¥÷¥¿½T¡GIFERROR(MONTH(Á`¤ÀÃþ±b´ú¸Õ!$A$1:$A$9999),"")=$B$2¡F¥H¤Î¬ì¥Ø¥¿½T¡GÁ`¤ÀÃþ±b´ú¸Õ!$B$1:$B$9999="Áʸm¶O" ³o¨â¥ó¨Æ±¡©ñ¨ì¦P¤@¼h¸Ì­±¡A§Æ±æ±N­ì¥»ªº
IF(IFERROR(MONTH(Á`¤ÀÃþ±b´ú¸Õ!$A$1:$A$9999),"")=$B$2,IF(Á`¤ÀÃþ±b´ú¸Õ!$B$1:$B$9999="Áʸm¶O",ROW(¤é°O±b!$A$1:$A$9999),""),"")
Åܬ°
IF(AND(IFERROR(MONTH(Á`¤ÀÃþ±b´ú¸Õ!$A$1:$A$9999),"")=$B$2, Á`¤ÀÃþ±b´ú¸Õ!$B$1:$B$9999="Áʸm¶O"),ROW(¤é°O±b!$A$1:$A$9999),"")¡A³o¼Ë´N¥i¥H´î¤Ö¤@¼h
µM«á¦A§âIFERROR§ï¦¨if(iserror(),"",...)¡A¼h¼Æ­è­è¦n°÷¥Î

¦ý¬O§Ú¦b¨Ï¥Î³o­Ó§ïÅܪº¨ç¼Æªº®É­Ô¡A¸ê®Æ´N·|¶]±¼¡A¤£ª¾¹D¬O«ç»ò¦^¨Æ¡A·Q½Ð¤j®aÀ°§Ú¬Ý¤@¤U¡AÁÂÁÂ

¦^´_ 1# Bodhidharma


    ½×¾Âªº°ª¤â³£·|§Æ±æ°Ý°ÝÃD®Éªþ¤WÀÉ®×
   ¦pªGÀɮצ³¤£¥i§i¤H¯µ±K
   ´N§â¤½¥q¦WºÙ®³±¼
   ¬ÛÃö¤H¦W³¡ªù®³±¼
   ¦Ü¤Öªþ¤W¤@ÂIÂI¨Ò¤l
   ³o¼Ë¥L­Ì·|¤ñ¸û®e©öÀ°¦£
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

§PÂ_¦h±ø¥óªº¸Ü¸Õ¸Õ¬Ý¥Î"SUMPRODUCT"³o­Ó¨ç¼Æ

TOP

¦^´_ 1# Bodhidharma

¦p¹Ï
I2°}¦C¤½¦¡
=IF(ROW(A1)>SUMPRODUCT(($A$2:$A$8=$G$2)*($C$2:$C$8=$H$2)),"",INDIRECT("B"&SMALL(IF(($A$2:$A$8=$G$2)*($C$2:$C$8=$H$2),ROW($2:$8),""),ROW(A1))))
  
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

    °Ú¡A­ì¨Ó¥Îif((²Å¦X±ø¨t¥óA)*(²Å¦X±ø¥óB),......)§Y¥i¡A«D±`·PÁ¡I

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD