G
Guest
If I have a list of numbers in colum "A".
A1: 10
A2: 20
A3: 00
A4: 15
A5: 50
A6: 25
I can get my answer by using this formula
=SMALL(A1:A5,COUNTIF(A1:A5,0)+1)
However, if I want the smallest number between certain cells like A1, A3, A4
which would give me an answer of 10, is that posible??
Thanks in advance
A1: 10
A2: 20
A3: 00
A4: 15
A5: 50
A6: 25
I can get my answer by using this formula
=SMALL(A1:A5,COUNTIF(A1:A5,0)+1)
However, if I want the smallest number between certain cells like A1, A3, A4
which would give me an answer of 10, is that posible??
Thanks in advance