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

¨D§ä¥X¿ù³B¡I¡I¡I¡I

¦^´_ 1# jason28921

­ì¨Ó
=OFFSET(A3,2-ROW(),MATCH(MAX(B3:E3),B3:E3),1,1)
§ï¬°
=OFFSET(A3,2-ROW(),MATCH(MAX(B3:E3),B3:E3,0),1,1)

©Î¬O²¤Æ¤@¨Ç
=OFFSET(A$2,,MATCH(MAX(B3:E3),B3:E3,))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD