Display Value In Next Column Over
Closed
Sam
-
Jul 17, 2009 at 01:36 PM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Display Value In Next Column Over
- Display multiple columns in a validation list - Guide
- Entering value for column at once, displaying in all sheets ✓ - Forum - Excel
- This column has more than 10000 unique items only the first 10000 unique items are displayed ✓ - Forum - Excel
- The page cannot be displayed. (80710a06) - Forum - Internet/Social Networks
- Write a program to display the first ten terms of the following series: a) 1, 11, 111, 1111, in c ✓ - Forum - Programming
1 reply
venkat1926
Jul 17, 2009 at 09:07 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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