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

½Ð°Ý´M§äªº¨ç¼Æ­n¦p¦ó³]

¦^´_ 1# wind6424
B18°}¦C¤½¦¡
=INDEX($A$4:$A$14,MATCH(1,1/(INDEX($A$4:$R$14,,MATCH(B16,$2:$2))>=B17),0),)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# aer


    ²Ä¤G¦C¤¤´M§ä
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# wind6424

°}¦C¤½¦¡
=MIN(INDEX($E$4:$E$14,MATCH(1,1/(F4:F14>=F16),0),),INDEX($E$4:$E$14,MATCH(1,1/(G4:G14>=F17),0),),INDEX($E$4:$E$14,MATCH(1,1/(H4:H14>=F18),0),),INDEX($E$4:$E$14,MATCH(1,1/(I4:I14>=F19),0),))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD