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

[µo°Ý] Åã¥Ü¦~Äְϰݸê®Æ

[µo°Ý] Åã¥Ü¦~Äְϰݸê®Æ

¦U¦ì¥ý¶i¦n¡A¤p§Ìªí¤º¤§¤H¨Æ¸ê®Æ¬O¦³Ãö©m¦W¤Î¦~ÄÖ¡A¸ê®Æ¤´·|«ùÄò¼W¥[¡A¦p»Ý¦C¥X¬Y¤@­Ó¦~Äְ϶¡ªº©Ò¦³¤H¸ê®Æ¡A¦Û¤v¸Õ¹L¦h­Ó¤½¦¡¤´µLªk¦³®Ä¦C¥X¡A½Ð°Ý­n¥Î¨º­Ó¨ç¼Æ¤½¦¡¡AÁÂÁ¡I³o­Ó¸ê®Æ·|¦b2003¤Î2007ªºª©¥»¨Ï¥Î¡I ¦~Äְ϶¡.rar (4.86 KB)

¥»©«³Ì«á¥Ñ ML089 ©ó 2017-5-23 20:54 ½s¿è

D2 =IF(AND(C2>=E$2,C2<=F$2),MAX(D$1:D1)+1,"")
¤U©Ô

H2 =IF(ROW()-1>MAX($D:$D),"",INDEX(A:A,MATCH(ROW()-1,$D:$D,)))
¥k©Ô¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089


    M¤j¦n¡A¥»¥H¬°·|¥Îª½±µÅã¥Üªº¤è¦¡¡A¦ý±z¥Î¥t¤@¶¡±µ»²§UÅã¥Ü¡A³o¤@¤è¦¡¾Ç²ß¤F¡AÁÂÁ¡I

TOP

¦^´_ 3# shan0948

¶i¶¥¿z¿ï

    [attach]27217[/attach]
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh


    H¤j±z¦n¡A¤£¦n·N«ä¡A¨S¦³¬Ý¨ì±zªºªþÀÉ¡AÁÂÁ¡I

TOP

C1¤U©Ô (¥|±Ë¤­¤J) =ROUND(YEARFRAC(B2,TODAY()),1)
H2¥k©Ô ¤U©Ô=IFERROR(INDEX(A:A,SMALL(IF(($C$2:$C$99>=$E$2)*($C$2:$C$99<=$F$2),ROW(C$2:C$99)),ROW(A1))),"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 7# hcm19522


    hcm¤j±z¦n¡A«ü¾Éªº¤½¦¡¥i¥H¥¿½TÅã¥Ü©Ò»Ý¸ê®Æ¡A¦ýH2ªº¤½¦¡»Ý§ï¦¨°}¦C¤½¦¡©l¥iÅã¥Ü¡A·PÁ«ü¾É¡I

TOP

´£¨ÑÀɮ׽аѦÒ

¦~Äְ϶¡_20170625.rar (7.76 KB)

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD