What function to select the last 3 small values from a list ?

E

Eric

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
 
B

bpeltzer

=SMALL({2,3,4,5,6,7,8},{1,2,3}) will return an array of the three smallest
values.
 
E

Eric

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
 
A

Aladin Akyurek

=OR(ISNUMBER(MATCH(IF({1,2,3,4,5,6,7,8,9}<=SMALL({1,2,3,4,5,6,7,8,9},3),{1,2,3,4,5,6,7,8,9},""),{2,3,7},0)))

which must be confirmed with control+shift+enter.
 
Top