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

you could try =SMALL(A1:A10,COUNTIF(A1:A10,0)+1)UNless there are negitives.

:: mike

Hi Mike, thanks for your answer it works a treat, Ta

Ask Your Question

Weekly Poll