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

¦p¦ó¨Ì¿é¤J¤º®e§PÂ_©ÒÄݪºÃþ§O

¦p¦ó¨Ì¿é¤J¤º®e§PÂ_©ÒÄݪºÃþ§O



¤j®a¦n¡A·Q½Ð±Ð¤j®a¦p¦ó¦bEÄæ¼g¤½¦¡¨Ó§PÂ_¦WºÙ©ÒÄݪºÃþ§O?

A©MBÄæ¬O§PÂ_°ò·Ç¡CD©ME«h¬O¹ê»Ú¨Ò¤l¡C
§PÂ_°ò·Ç¡G
(1) ­Y¦WºÙ¸Ì§t¦³¡u/S¡v¡A«h§PÂ_¬O¡u¤p¡v
(2) ­Y¦WºÙ¸Ì§t¦³¡u/SS¡v¡A«h§PÂ_¬O¡u¶W¤p¡v
(3) ­Y¦WºÙ¸Ì§t¦³¡u11¡v¡A«h§PÂ_¬O¡u11¡v(¹ê¨Ò¤W¡A11·|¥X²{¦b¦WºÙªº«e­±)
(4) ­Y¦WºÙ¸Ì§t¦³¡u30¡v¡A«h§PÂ_¬O¡u30¡v(¹ê¨Ò¤W¡A30·|¥X²{¦b¦WºÙªº«e­±)
(5) ­Y¦WºÙ¸Ì§t¦³¡u32¡v¡A«h§PÂ_¬O¡u32¡v(¹ê¨Ò¤W¡A32·|¥X²{¦b¦WºÙªº«e­±)
(6) °£¤F¥H¤W¤§¥~ªº¡A§PÂ_¬O¡u¤@¯ë¡v

¥Ø«e¹Á¸Õ¤F¦ýÁÙ¬O¸Õ¤£¥X¨Ó¡A·Q³Â·Ð¦U¦ì¨ó§U¡AÁÂÁ¤j®a¡C

123.zip (7.4 KB)

=LOOKUP(1,-FIND(A$2:A$7,D2),B$2:B$7)

TOP

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

TOP

¦^´_ 2# ­ã´£³¡ªL


   
ÁÂÁ­㴣³¡ªL¤j¤jªº¦^ÂСAÁÂÁ¡C

TOP

¦^´_ 3# hcm19522


ÁÂÁÂhcm19522¤j¤jªº¦^ÂСAÁÂÁ¡C

TOP

Hello, ­ã¤j

½Ð±Ð, §A©Ò¦^ÂЪº³o­Ó¤½¦¡OOKUP(1,-FIND(A$2:A$7,D2),B$2:B$7).

1. Find ¨ç¼Æ«e, ¥[¤W"-"ªº¥Î·N¬°¦ó? ¯à§_¸ÑÄÀ¤@¤U?
2. ¥tLookup ¨ç¼Æ, §ä¤£¨ì¨ä¤ñ¹ï­È(¦p33 or ªÅ®æ)®É, ¥i¦³¤èªk§P§O¥X¨Ó?

Thanks ~
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-7-30 20:06 ½s¿è

¦^´_ 6# ¼B¤j­G

¥["-"¸¹, Åýfind¥X¨Óªº­È¬Ò§e"­t¼Æ", ¦p¦¹lookup(1,~~)¥²¯à§ä¨ì³Ì«á¤@µ§²Å¦X¸ê®Æ,
¥»©«A2¬°ªÅ®æ, FIND("","???") ¥²µ¥¤_1, §Y§ä¤£¨ì²Å¦X®É, ¥u·|¹ïÀ³¨ìA2ªº¦ì¸m~~
¤]¦]¬°¦³A2ªºªÅ®æ, ©Ò¥H¹J¨ì33©Î¨ä¥¦¤£¦s¦bªº­È, ³£µLªk¥h°Ï§O¤F!!

TOP

¦^´_ 7# ­ã´£³¡ªL

Hello, ­ã¤j

¤F¸Ñ! ÁÂÁ§Aªº¸Ñ»¡....
Thanks ~
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD