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

[µo°Ý] ¤j©ó0ªº¸ê®Æ¦Û°ÊÅã¥Ü

H3//°}¦C¤½¦¡:
=IFERROR(SMALL(IF(($B4:$G4>0)*($A3<>""),$B3:$G3),COLUMN(A$1)),"")  ¤U©Ô

®æ¦¡±ø¥ó:
B3: =B3/B4

TOP

¦^´_ 8# PJChen


H4:
=IF(H3="","",INDEX($B$2:$G$2,MATCH(H3,$B3:$G3,)))

¦P®É¿ï¨ú¨â¦æ, ©¹¤U¶K¤½¦¡~~

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD