Finding the 3 best values

  • Thread starter Thread starter Santafe
  • Start date Start date
S

Santafe

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.
 
Are "best " values the low ones (like golf) or the high ones (like bowling) ?
 
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.
 
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.
Click to expand...

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
 
Hello,

The best 3 of the first 4:
Select 3 cells - for example A4:C4 and array enter:
=LARGE(A2:D2,{1,2,3})

The worst 3 of the last 4:
Select 3 cells - for example A5:C5 and array enter:
=SMALL(E2:H2,{1,2,3})

Array-enter with CTRL + SHIFT + ENTER, not only with ENTER.

Regards,
Bernd
 
Back
Top