Previous Topic Next Topic

Display Value In Next Column Over

Closed
Sam - Jul 17, 2009 at 01:36 PM
venkat1926 Posts 1863 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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

The page cannot be displayed. (80710a06)
anymay -
RAY -

2 responses
Excel - To generate unique ID
wliang -
ferg -

4 responses
ps3 network error 80710a06
naf -
Ambucias -

5 responses
Confirm your identity with phone or computer
Sajibdas217@gmail.com -
ElenaKM -

1 response
Ps3 network problem
dan lekah -
Ambucias -

3 responses