Finding the 3 best values
On Dec 5, 4:04*pm, Santafe wrote:
Hi,
Consider these values:
122 *170 * *85 * 150 * 2286 *2265 *2398 *2198
I calculated te best of 3 form the four first values = 170 150 122
Now I need to find the corresponding value in the last 4 values, wich should
be 2265 * 2198 *2286.
Thanks for your intrest in my problem.
"Gary''s Student" wrote:
Are "best " values the low ones (like golf) or the high ones (like bowling) ?
--
Gary''s Student - gsnu200909
"Santafe" wrote:
*I have a worksheet, where in the same row is a range of numbers and another
range of times. *The fist time corespond to the first number, the second time
corresponds to the second number, and so on ...
From the range of numbers I have calcutated the best of 3. *Now I like to
find the times that correspond to those 3 numbers. * Preffably using a
function or combination of fuctions.
Thanks for helping me out.
If the first four are in A2:D2 and the last four are in E2:H2 and the
first of the best of the first four is in A1, then try...
=INDEX($E$2:$H$2,0,MATCH(A1,$A$2:$D$2,0))
Ken Johnson
|