MIN or DMIN ?

  • Thread starter Thread starter Guest
  • Start date Start date
If there are no negative values

=LARGE(A1:A30,COUNTIF(A1:A30,">0"))

if there are negative values

=MIN(IF(A1:A30<>0,A1:A30))

the latter needs to be entered with ctrl + shift & enter

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

lowest number in a set EXCLUDING zero 2
Function DMIN? 3
Return Min & Cell address 7
Min of range where other col has a value 3
FInding Min Value with Criteria 11
Conditional formula using MIN function doesn't work 5
Min excluding zero values, without an array fomrula 13
How do I modify database criteria at formula level? 3

Back
Top