Hello All, Using Excel 2007
I have the following sample worksheet:
A
1 2
2 0
3 14
4 7
5 1
How can I get the smallest value in A1:A5 that is NOT a zero. (in this case 1)
I have tried {=small(if(A1:a5=0,"",small(a1:a5,1)))} and I get the error "too few arguments" for this function.
Any help would be appreciated.
Mike
Bookmarks