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) ?
--
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.

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.

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

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

Hi Ken,

It is working, I heve the needed result.

Thanks very much.

"Ken Johnson" wrote:

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
.