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

[µo°Ý] ¨Ï¥Î³¡¤À¼Ò½k·j´M¥\¯à¬ÛÃö...§e²{©Ò»Ý¤å¦r

[µo°Ý] ¨Ï¥Î³¡¤À¼Ò½k·j´M¥\¯à¬ÛÃö...§e²{©Ò»Ý¤å¦r

¦³¤@¤u§@ªí¦WºÙ¬°¨Æ¥Ñ¡A
¸ê®Æ½d³ò¬°A1:E31¡A§Æ±æ¦bG·j´MÄæG2¡BG3¡K¿é¤J¨Æ¥Ñ¤º¬ÛÃö¦rµü
¦A¨Ì¾ÚF2¡BF3¡K¦Û¦æ¿é¤JÅã¥Ü¬ì¥Ø¤º®e(B1:E1)¤ñ¹ï¤å¦r¡A±N²Å¦X¤§¨Æ¥Ñ¤å¦r±a¤JH2¡BH3¡K¥H¦¹Ãþ±À¡AH2¤½¦¡¬°¦ó?
1.¸ê®Æ½d³ò¬°A1:E31
2.FÄæ¿é¤J¬ÛÃö¤£¦P¸ê®Æ¼Æ¾Ú
3.·j´M¬°¿é¤J³¡¤À¡B¼Ò½k¬d§ä¤º®e¤å¦r
4.§Æ±æµ²ªGÅã¥Ü¤ñ¹ï²Å¦X¤§¨Æ¥Ñ¤å¦r
5.­YF¡BGÄæµL¸ê®Æ¼Æ¾Ú®É¡AHÄæ¬ÛÃö¦C«hÅã¥ÜªÅ¥Õ

6.jpg
2024-9-6 00:46


1130906+.rar (8.63 KB)

¼Ò½k¬d§ä(·j´M¿é¤J½s¸¹ 13150) googleºô§}:https://hcm19522.blogspot.com/
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522

·PÁ hcm19522 «ü¾É¤À¨É

H2{=INDIRECT(TEXT(MAX((B$1:E$1=F2)*ISNUMBER(FIND(G2,B$2:E$5))*ROW($2: $5)/1%+COLUMN(B:E)),"!R0C00"),)
«D±`¯S®íªº§t¸q ¨Ï¥ÎTEXT(..., "!R0C00") ±N³o­Ó³Ì¤j­ÈÂà´«¬°¯S©wªº¦r²Å¦ê®æ¦¡
"!R0C00" ¬O¤@ºØ±N¦æ¦C½s¸¹Âà´«¬° Excel ³æ¤¸®æ¤Þ¥Îªº®æ¦¡¡A¨Ï¥Î R1C1 ¤Þ¥Î¼Ë¦¡¡A¨ä¤¤ R ©M C «á­±ªº¼Æ¦rªí¥Ü¦æ©M¦Cªº¯Á¤Þ¡C

¥t¸Ñ{=LOOKUP(9,-
FIND(G2,HLOOKUP(F2,B:E,ROW($1:$99),)),HLOOKUP(F2,B:E,ROW($1:$99),))

TOP

¦^´_ 3# cypd ¦³¥t¤@¸Ñ
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522

ÁÂÁ  hcm19522
°Ñ¦Ò¦p¤U
¼Ò½k¬d§ä(·j´M¿é¤J½s¸¹ 13150) googleºô§}:https://hcm19522.blogspot.com/

TOP

¤@¯ë¤½¦¡//
µù:B/EÄæ"¯Â¼Æ¦r"½Ð¥H¤å¦r®æ¦¡¿é¤J~~
=IF(OR(F2="",G2=""),"",VLOOKUP("*"&G2&"*",INDEX(A:E,,MATCH(F2,A$1:E$1,)),1,))

TOP

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

·PÁ ­ã´£³¡ªL ª©¥D
´£¨Ñ¤@¯ë¤è¦¡¥t¸Ñ¤è¦¡¸Ñµª

TOP

¦^´_ 6# ­ã´£³¡ªL
½Ð°Ý¦³¨S¦³¨ä¥L´À¥NVLOOKUPªº¤è¦¡
¥Î³o­Ó¨ç¼Æ¤Ó¦hµ§¸ê®Æ·Pı¾ã­ÓÀɮ׳£ÅܫܺC

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD