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

[µo°Ý] ½Ð°Ý¦p¦ó¨Ì¾Ú A367»P B370 ¨ú±o D370ªº­È=52

[µo°Ý] ½Ð°Ý¦p¦ó¨Ì¾Ú A367»P B370 ¨ú±o D370ªº­È=52

¥»©«³Ì«á¥Ñ lcctno ©ó 2019-1-16 13:04 ½s¿è

¦p¹Ï ¥Ñ©ó³o¾ã­Ó¼Æ¾Ú ¦ì¸m¤£¤@©w·|©T©w¦b¬Y¤@¦C ¤]´N¬O»¡A367 ©Î³\ ·|ÅܨìA368 A379 ¬Æ¦Ü A269 ..... ¤Ï¥¿¸g±`·|Åܦì¸m
½Ð°Ý¦p¦ó¨Ì¾Ú "¯à·½" »P "WTI­ìªo" ³o2²Õ¤å¦r ¨ú±o D370ªº­È=52
ÁÂÁ°ª¤âªº±Ð¾É


½d¨Ò1.JPG
2019-1-16 12:59





½d¨Ò.zip (13.59 KB)

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ lcctno ©ó 2019-1-17 07:37 ½s¿è

¦^´_ 2# hcm19522

·PÁ±z ¦ý§Ú¨Ì·Ó¨Ï¥Î J362=OFFSET(D1,MAX(IFERROR(MATCH(SMALL(IF(A1:A999="¯à·½",ROW(A1:A999)),ROW($1:$9)),IF(B1:B999="WTI­ìªo",ROW(A1:A999)-3),),))-1,)
µ²ªG¬O¦p¹Ï ¤£ª¾¬O­þ¸Ì¿ù¤F Áٽбz«ü¾É ÁÂÁÂ


½d¨Ò2.JPG
2019-1-17 07:22



½d¨Ò.zip (13.53 KB)

TOP

¦^´_ 3# lcctno


    {=OFFSET(D1,MAX((A1:A996="¯à·½")*(B4:B999="WTI­ìªo")*ROW(4:999))-1,)


2003ª© µLIFERROR    ¼Æ²Õ¤½¦¡ :½Æ»s¤½¦¡ ¤£§t "=" ,¶K¤W«á¥[ "="   ;³Ì«e "{" ¥Nªí shift+ctrl+enter ¤TÁä¤@°_«ö©Ò²£¥Í ,«Dµ{¦¡¸Ì­±
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522
¨Ï¥Î¨ç¼Æ=OFFSET(D1,MAX((A1:A996="¯à·½")*(B4:B999="WTI­ìªo")*ROW(4:999))-1,)
¥i¥H¥Î¤F ¯uªº«Ü·PÁ±z(°ª¤â)

TOP

=LOOKUP(,-SEARCH("WTI­ìªo????¦~*¤ë",B1:B999&C1:C999),D:D)

TOP

¦^´_ 6# ­ã´£³¡ªL
=LOOKUP(,-SEARCH("WTI­ìªo????¦~*¤ë",B1:B999&C1:C999),D:D)
³o­Ó¤]«Ü¦n¥Î ÁÂÁ±z¤F

TOP

=VLOOKUP("WTI­ìªo",OFFSET(B1,MATCH("¤ë¥÷",C:C,),,999,3),3,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# ML089

=VLOOKUP("WTI­ìªo",OFFSET(B1,MATCH("¤ë¥÷",C:C,),,999,3),3,)
³o­Ó¤]«Ü¦n ÁÂÁ±z¤F

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD