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
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,
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,
Related:
- This column has more than 10000 unique items only the first 10000 unique items are displayed
- Outlook duplicate items remover (odir) - Download - Email
- All 580 little alchemy items - Guide
- The page cannot be displayed. (80710a0 - Internet & Social Networks Forum
- The page cannot be displayed. (80710a06) - Google Forum
- The page cannot be displayed. (80710a06 ✓ - PS3 & PS4 Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 17, 2009 at 09:07 PM
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
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
