ªð¦^¦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Åã¥ÜªÅ¥Õ



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

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD