View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Santafe Santafe is offline
external usenet poster
 
Posts: 5
Default Finding the 3 best values

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.