Previous Topic Next Topic

Simple Excel Question (I think)

Solved/Closed
ruh-roh - Nov 3, 2009 at 04:35 PM
 ruh-roh - Nov 5, 2009 at 08:32 AM
Hello,
I am putting together an XL sheet and would like to find the MAX value in a column of numbers, then return the contents of the cell next to it. For example, out of 10 test scores (cells B1 through B10), I would like to first identify the highest score, then look in Column A for the name of the student the high score belongs to, then display the student's name in cell C1. Any suggestions on how to accomplish this would be very much appreciated. Thanks!
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 5, 2009 at 06:17 AM
=INDIRECT("A"&MATCH(MAX(B1:B10),B1:B10,0))

if necessary modify the macro
0
Answer 2 / 2
ruh-roh
Nov 5, 2009 at 08:32 AM
Sweet! Thnaks very much -- this really helps out!
0

Similar discussions

Keyboard troubles
jimbobjoe -
car -

38 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses