| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding minimum value | Excel Programming | |||
| Finding a Minimum Number other than Zero within a Range | Excel Programming | |||
| finding minimum value excluding zero | Excel Discussion (Misc queries) | |||
| Finding a minimum value and selecting the cell containing this val | Excel Worksheet Functions | |||
| PROBLEM FINDING MINIMUM | Excel Programming | |||
Linear Mode
