ªð¦^¦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 : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD