What function to select the last 3 small values from a list ?
Does anyone know how to select the last 3 small values from a list? such as
a list {1,2,3,4,5,6,7,8,9} then reture the last 3 small value {1,2,3} Thank you for any suggestion Eric |
What function to select the last 3 small values from a list ?
=SMALL({2,3,4,5,6,7,8},{1,2,3}) will return an array of the three smallest
values. "Eric" wrote: Does anyone know how to select the last 3 small values from a list? such as a list {1,2,3,4,5,6,7,8,9} then reture the last 3 small value {1,2,3} Thank you for any suggestion Eric |
What function to select the last 3 small values from a list ?
Thank you for your suggestion.
I would like to go further ... Does it have a single function to perform the similar task? Given Lists {1,2,3,4,5,6,7,8,9} Given number {2,3,7} Condition: If any given number equals to any last 3 small integers, such as {1,2,3} in this case, then TRUE. 2 is TRUE 3 is TRUE 7 is FALSE Does anyone have any idea? Thank you Eric "bpeltzer" wrote: =SMALL({2,3,4,5,6,7,8},{1,2,3}) will return an array of the three smallest values. "Eric" wrote: Does anyone know how to select the last 3 small values from a list? such as a list {1,2,3,4,5,6,7,8,9} then reture the last 3 small value {1,2,3} Thank you for any suggestion Eric |
All times are GMT +1. The time now is 09:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com