Hi there,
I have to find the smallest value different from zero in an array. So far so good:
=SMALL(A2:E2,COUNTIF(A2:E2,"<=0")+1)
The issue is that I should not consider certain cells (columns) in that array (e.g. consider A, C, D only).
Very trivial question but cannot sort this out. What Is the correct syntax?
A2,B2, ...
A2 & B2 ....
Thanks,
M
Bookmarks