ExcelBanter - Finding the MIN value, but greater than zero

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Finding the MIN value, but greater than zero (https://www.excelbanter.com/excel-discussion-misc-queries/195642-finding-min-value-but-greater-than-zero.html)

Glenn L.[_2_]

Finding the MIN value, but greater than zero

I need to find the minimum value in a data range (F174:F188), but greater
than zero. I tried "=MIN(F174:F1880)" and it does not work. How can I do
this?

Mike H

Finding the MIN value, but greater than zero

Try

=MIN(IF(F174:F188 0,F174:F188))

Enter with Ctrl+Shift+Enter NOT just enter

Mike

"Glenn L." wrote:

I need to find the minimum value in a data range (F174:F188), but greater
than zero. I tried "=MIN(F174:F1880)" and it does not work. How can I do
this?

Glenn L.[_2_]

Finding the MIN value, but greater than zero

Worked like a charm! Thanks for taking the time to help, Mike!!

"Mike H" wrote:

Try

=MIN(IF(F174:F188 0,F174:F188))

Enter with Ctrl+Shift+Enter NOT just enter

Mike

"Glenn L." wrote:

I need to find the minimum value in a data range (F174:F188), but greater
than zero. I tried "=MIN(F174:F1880)" and it does not work. How can I do
this?

All times are GMT +1. The time now is 01:33 PM.