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

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

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

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD