View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default 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