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

[µo°Ý] ¦hÄæ¦ì¬d¸ß

[µo°Ý] ¦hÄæ¦ì¬d¸ß

¦U¦ì¥ý¶i¦n
½Ð°Ý¦pªG¦³±ø¥ó1.2.3ªºÄæ¦ì­n§@¬d¸ß¦ý­n¶Ç¦^ÄæAªº­È
=IF(IFERROR(VLOOKUP($F$6,IF({1,0},±ø¥ó¤@,¥DÃD),2,FALSE),"")="",IFERROR(VLOOKUP($F$6,IF({1,0},±ø¥ó¤G,¥DÃD),2,FALSE),""),IFERROR(VLOOKUP($F$6,IF({1,0},±ø¥ó¤@,¥DÃD),2,FALSE),""))
¬O§_¦³¿ìªk²¤Æ...¦pªG±ø¥ó¹L¦h..¤½¦¡´N·|¶VÅܶVªø

³Â·Ð¦U¦ì¥ý¶i¤F test1.rar (6.39 KB)

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

G6/°}¦C¤½¦¡:
=IF(F6="","",INDEX(A:A,MAX((B2:D15=F6)*ROW(2:15))))

TOP

·PÁ¦U¦ì¥ý¶iªº«ü¾É..
¦ý¦pªG¿é¤J±ø¥ó¹L¦h,¶]°}¦Cªº¹Bºâ³t«×·|¹Lªø...
½Ð°Ý¬O§_¥i¥ÎVBAªº¤è¦¡¸Ñ¨M

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD