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

[µo°Ý] ¤ñ¸û¤é´Á§ì¥X²Å¦X±ø¥óªº¸ê®Æ

[µo°Ý] ¤ñ¸û¤é´Á§ì¥X²Å¦X±ø¥óªº¸ê®Æ

¦bsheet2ªºE3¿é¤J¤@­Ó¤é´Á¡AµM«á§âsheet1¤¤FÄæ¦ì¤j©ó³o­Ó¤é´Á©M¼Ðµù"HOLD"¤Î"To be advised"ªº¸ê®Æ§ì¦^sheet2¤¤¡A¸Õ¤F«Ü¤[¡A·d¤£©w¡C
test.rar (19.79 KB)
Jess

C6:C18{=IFERROR(INDEX(¤u§@ªí1!B:B,SMALL(IF(¤u§@ªí1!$F$3:$F$13>$E$3,ROW(F$3:F$13)),ROW(A1))),"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522
ÁÂÁ¤j¤jªº¦^ÂСA¤w§ä¨ì°ÝÃD¡A­ì¨Ó¬O[E3]³Q«ü¦V¿ù»~ªº¤u§@ªí¤F¡C
Jess

TOP

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