hi
i have a list here:
A....B....C....D
73 4 565 -273
29 17 220 273
31 13 318 85
30 14 296 124
23 20 133 327
29 17 220 273
28 18 196 308
24 19 164 292
I need a formula which states:
Check what is the largest number from column D (K21:K28, which is 327) and then get the number represented in column A (H21:H28, which is 23).
If for example the largest number would be 292 (last one in list) then the final result would be 24.
How can I produce this formula?
Thanks!
Bookmarks