Finding the 3 best values
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. |
Finding the 3 best values
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. |
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. |
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 |
Finding the 3 best values
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 |
Finding the 3 best values
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 . |
All times are GMT +1. The time now is 08:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com