Here's one way:
=SMALL(A1:A20,COUNTIF(A1:A20,0)+1)
counts the number of zero's and gives you the next smallest number that
isn't zero. This assumes values in column A, thru row 20, adjust as
necessary.
I kinda figured that was a safe assumption, if MIN was giving him the zero,
but you're right, I should have said so.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.