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???
|