View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default What function to select the last 3 small values from a list ?

On Fri, 30 Dec 2005 17:31:03 -0800, "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


The SMALL worksheet function will do that.

The specifics depend on the nature of your list and the result specifications.



--ron