Conditional Format for Smallest Numbers excluding 0

[TengoKbailar]

Hi.
I have a column of numbers and I am trying to highlight the smallest numbers excluding 0
I have tried
IF(AND(AA358>0,AA358<=SMALL(AA$3:AA358,AA359)))
I then use the format paintbrush on the whole column which leaves all the 0s without any format but 0 is still being counted in SMALL and each 0 is being counted individually so if there are 20 X 0s I do not see any format until I enter 21 into AA359 and I am looking for the smallest 10


I have searched and Googled for an answer but not found one so I am hoping that someone can help me with this.

Thanks

Michael

[CSLam]

For locating the smallest number, I can think of two solutions :-

(1)
If your column is just a column of values, use Global Replace changing all "0" to nul.
In such a way, the MIN() function will only report the smallest value next to zero.

(2)
If your column contains at least some formula, which can calculate to zero,
try using this :-
MIN(IF(A1:A1048576=0,999,A1:A1048576)),
where
(i)
A1:A100 is the column being considered;
(ii)
999 an arbitrary number big enough not to be the smalleest value;
(iii)
this is an array function: after entering the formula, you will need to hold down both Shift & Control together, then press the Enter key. You should see
{MIN(IF(A1:A100=0,999,A1:A100))}
in the status bar, ie. the formula enclosed by curly brackets.

I hope this helps.

CSLam