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
|