Finding smallest number

Try

=MINA(value1,value2,...)


It returns the smallest value in the list of arguments. Text and logical values such as TRUE and FALSE are compared as well as numbers.

Hope it helps

sorry forgot to add:


for the small formula i believe it is =SMALL(array,number you want to find eg 4th smallest)

oh, also there is =MIN(number1,number2,...)
e.g =MIN(A1:A10)

Number1, number2, ... are 1 to 30 numbers for which you want to find the minimum value.


Hope the above help as well