Display Value In Next Column Over Closed

Question

Hello,
This is probably a simple one for most people, but I'm new to Excel and am still getting used to it.
Basically, I want to find the max value in one column, but pull and display the value in the next column over.

Column A is Time, Column B is Amount. I want to display the Time associated with the greatest Amount in a single cell, we'll call it C1 just to make it simple, because I need to use the time in another equation down the line.

What equation do I write into C1 to do this?

Thanks,

venkat1926 · Accepted Answer

for e.g. your sheet is like this from row no. 1 down

time	amount
1	4
2	55
3	80
4	69
5	92
6	56
7	46
8	40
 In C2 copy paste this formula and see 

=INDEX($A$1:$A$9,MATCH(MAX($B$2:$B$9),$B$1:$B$9,0),1)

see help on index-match in excel worksheet help

Display Value In Next Column Over

1 response

Similar discussions

Subscribe To Our Newsletter!