Solved Formula to look beyond 0

January 25, 2013 at 02:35:44
Specs: Windows 7
Hi I am trying to create a formula for Small I know how to do the formula but what I need is for the small to look after 0 with the formula, =SMALL(B:B,1) it will return 0 as I have them in the range so I need something that looks after the 0 and return the figures above the 0

See More: Formula to look beyond 0

Report •


#1
January 25, 2013 at 05:54:48
✔ Best Answer
you could try

=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)

UNless there are negitives.

:: mike


Report •

#2
January 25, 2013 at 20:31:20
Hi Mike, thanks for your answer it works a treat, Ta

Report •

Related Solutions


Ask Question