S5 Scores Copy
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
#โ†’ Momentโ†’ You did it!Final Score
2
!5
3
21039000
4
31024000hi
5
41050000
you wanna return it in D2?
6
51100000Oh, hi. yep.
7
I'm not changing anything, just looking, by the way.
8
np
9
10
11
https://webapps.stackexchange.com/a/126187/186471
12
done
13
ok?
14
15
Yeah. Thanks.
16
Could you explain what every part of that does? I have no idea what =OFFSET or =INDIRECT even are.
17
18
sure
19
=OFFSET(INDIRECT(CELL("address", INDEX(D3:D, MATCH(MAX(D3:D), D3:D, 0), 1))), 0, -3)
20
21
OFFSET will ofset cell based on numbers 0 and -3 where 0 is row and -3 is actual column (D) -3 which equals column A
22
INDIRECT will create reference from value - it kinda converts value/string D4 into actual cell reference
23
CELL will find the address/cell reference of the max value and return it as a value (D4)
24
INDEX will look on the whole range, find where MAX value is (on which row)
25
26
any other questions?
27
28
No, but again... Thanks so much.
29
That is so cool...
30
Done.
31
thx
anything else I can help with?
32
Not for now, thanks for asking, though.
33
No problem.
kk, see you next time :)
34
35
The first time I tried this was in Excel. I failed with =VLOOKUP and gave up๐Ÿ˜…
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...