ExcelBanter - finding a minimum

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - finding a minimum (https://www.excelbanter.com/excel-programming/430844-finding-minimum.html)

David Netser

finding a minimum

how can i find a the smallest number in a row (min function), provided that
its not zero. i am looking for something which is equivalent to sumif.
thanks, david

Rick Rothstein

finding a minimum

You can use this array-entered** formula to do that...

=MIN(IF(A2:J20,A2:J2,""))

**commit this formula using Ctrl+Shift+Enter, not just Enter by itself

--
Rick (MVP - Excel)

"David Netser" wrote in message
...
how can i find a the smallest number in a row (min function), provided
that
its not zero. i am looking for something which is equivalent to sumif.
thanks, david

David Netser

finding a minimum

Rick, many thanks it works perfectly, rgds, david

"Rick Rothstein" wrote:

You can use this array-entered** formula to do that...

=MIN(IF(A2:J20,A2:J2,""))

**commit this formula using Ctrl+Shift+Enter, not just Enter by itself

--
Rick (MVP - Excel)

"David Netser" wrote in message
...
how can i find a the smallest number in a row (min function), provided
that
its not zero. i am looking for something which is equivalent to sumif.
thanks, david

All times are GMT +1. The time now is 09:34 AM.