If I have a column of different values that are all greater than or equal to zero, is there a simple formula I can use to find the smallest value in the list that's not equal to zero?
If I have a column of different values that are all greater than or equal to zero, is there a simple formula I can use to find the smallest value in the list that's not equal to zero?
Hello
If for example your numbers where in A1:A20, the following array formula (entered with Ctrl+Shift+Enter) should return the smallest number greater than zero:
Formula:Please Login or Register to view this content.
If entered correctly you should see curly brackets {} around the formula in the Formula Bar.
Hope this helps.
DBY
Or with this regular formula
Formula:Please Login or Register to view this content.
v A B C 1 3 2 9 3 3 0 4 5 5 4
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks