View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default selecting the two lowest numbers

The Small function finds the lowest nth item in a range, as in:

=small(a1:a5,1)+small(a1:a5,2)

Regards,
Fred.

"Muz" wrote in message
...
Hi

I am trying to place the two lowest numbers from a selection into a
formula
eg:

selection = 1,3,5,6

Then my formula would be : say 1+3

any ideas???