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

Index+Small+If+Row ¨ç¼Æ

Index+Small+If+Row ¨ç¼Æ

¨Ï¥Î³o­Ó¨ç¼Æ®É¥d¨ì¤F
±N¤u§@ªí¤@¿é¥X¨ì¤u§@ªí¤Gªí®æ¹J¨ìªº°ÝÃD


¹Ï¤ù¤¤¯B¥Xªº¥Õ®æ¬O¤£À´ªº
¬õ¦â¦ì¸m§Ú³]©w¤F



¦ý¿é¥Xªº¸ê®Æ¬O¿ù»~ªº, ¨D¥¿½T¤èªk²\¥d¤F¨â¬P´Á
¥»¨Ó·Q¬O¥ÎIndex+Small+If+Row¨Ó³B²z, ·Q¦C¥X¤u§@ªí1 LOOKUP ¤u§@ªí¤GN3«á ¦C¥XH¦æªº­È(­n¤£­«½Æ)
¥t¥~´N¬O·Q¸Ñ¨M±¼¤u§@ªí1 PKEY ªº¥X²{, PKEY À³¸Ó¬O§C¶¥ªº§@ªk,¬O¥Î¨ÓLOOKUP¤u§@ªí¤Gªº¼Æ­È
ÁÂÁ¤j¤j

Demo.zip (10.35 KB)

¢Ô¢²¡þ°}¦C¤½¦¡¡G
=INDEX(¤u§@ªí1!$H:$H,MIN(IF((¤u§@ªí1!$C$1:$C$29=$N$3)*(COUNTIF($E3:E3,¤u§@ªí1!$H$1:$H$29)=0),ROW($1:$29),4^8)))&""

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD