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

[µo°Ý] ¦p¦ó³]©w¦Û°Ê§ì¨ú¤À¶q³æ»ù

[µo°Ý] ¦p¦ó³]©w¦Û°Ê§ì¨ú¤À¶q³æ»ù

¥Ñ©ó¤u§@¤W»Ý­n,±Ä¶R®É»Ý¤ñ¹ï¤À¶q³æ»ù, ¤£ª¾¹DÀ³¸Ó«ç»ò³]©w¤~¦n
QA.jpg

¦Û°Ê§ì§å¶qªº³æ»ù.rar (8.83 KB)

§ì¨ú¤À¶q³æ»ù

E3:
=INDEX(¸ê®Æ®w!E:E,-LOOKUP(,-MATCH(1,(¸ê®Æ®w!$D$1:$D$9>=$D3)/(¸ê®Æ®w!$A$1:$A$9=$A3)/(¸ê®Æ®w!$B$1:$B$9=$B3),{1,0})))&""

©Î:Àx¦s®æ®æ¦¡³]¦¨"#", ¥h±¼«á­±ªº&""

¸ê®Æ®w¥²¶·¥H"¼Æ¶q"»¼¼W±Æ§Ç~~

TOP

E3:G6{=IFERROR(LOOKUP(1,0/(¸ê®Æ®w!$A$2:$A$99=$A3)/(¸ê®Æ®w!$B$2:$B$99=$B3)/(¸ê®Æ®w!$C$2:$C$99=$C3)/(¸ê®Æ®w!$D$2:$D$9<=$D3),¸ê®Æ®w!E$2:E$99),INDEX(¸ê®Æ®w!E:E,MIN(IF((¸ê®Æ®w!$A$2:$A$99=$A3)*(¸ê®Æ®w!$B$2:$B$99=$B3)*(¸ê®Æ®w!$C$2:$C$99=$C3),ROW($2:$99)))))
ÀH·NºÛ "EXCEL°g"  blog  ©Î http://blog.xuite.net/hcm19522/twblog[img][/img]
¤w¦¬¶°7000½g EXCEL¨ç¼Æ

TOP

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


    ÁÂÁÂ~~¥i¥H¦Û°Ê§ì¨ú¤À¶q³æ»ù¤F!!~¤j·PÁÂ:)

TOP

E3:G6{=IFERROR(LOOKUP(1,0/(¸ê®Æ®w!$A$2A$99=$A3)/(¸ê®Æ®w!$B$2B$99=$B3)/(¸ê®Æ®w!$C$2C$99=$C3)/(¸ê ...
hcm19522 µoªí©ó 2021-2-9 12:19



    ÁÂÁÂ~~³o­Ó¨ç¼Æ¤]¬Û·í¹ê¥Î ¸Ñ¨M§Ú¦n´X¶gªº§xÂZ ¤j·PÁÂ!!~ :)

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD