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
.