ExcelBanter - MIN IF >0

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - MIN IF >0 (https://www.excelbanter.com/excel-worksheet-functions/8259-min-if-%3E0.html)

Bruce

MIN IF >0

I want to find the Min value of a range that is greater than 0.

Min (A1:A5) but ingore zero values.

Bruce

Max

One way ..

Try: =MIN(IF(A1:A50,A1:A5))
Array-enter the formula,
i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Bruce" wrote in message
...
I want to find the Min value of a range that is greater than 0.

Min (A1:A5) but ingore zero values.

Bruce

All times are GMT +1. The time now is 10:36 PM.