Previous Topic Next Topic

Display Value In Next Column Over

Closed
Sam - Jul 17, 2009 at 01:36 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 - Jul 17, 2009 at 09:07 PM
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,

1 reply

Answer 1 / 1
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 805
Jul 17, 2009 at 09:07 PM
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
2