Minimum formula the excludes zeros

G

Guest

My column contains formulars that total weekly share prices, this shows zeros
because that weeks prices are still to be entered, or the week is a future
week.
I require a fomular that shows the minimum total, excluding the zeros.

current formula =min(a5:a35)

Thanks for any help
Joco
 
G

Guest

current formula =min(a5:a35)

Try something like:
=MIN(IF(A5:A35>0,A5:A35))
Array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER)
 
G

Guest

Max thanks formula works great.
Would quite like to be in Singapore right now, weather in London is not good
thanks again Joco
 

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.

Ask a Question

Similar Threads

Minimum array formula. 5
Formula With A Minimum Value 1
changing multiple column references in a formula 5
In part of a col of data, I need the minimum number, but exclude z 10
Using Min Formula with Multiple Criteria Excluding Zeros 5
Formula Help (IF) ... INDEX 1
Pass The Formulas Please 3
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10

Top