can I use MIN function to find lowest, NON-ZERO or blank value? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              perplexed 3/9/2006 1:36 PM PST   Question   I am trying to analyze a large block of data where not all columns have an entry. I want to find the lowest value (but greater than zero or a blank cell) and write it into a separate column.     Was this post helpful to you?         Reply |   Top           Bob Phillips 3/9/2006 2:30 PM PST   Answer   =MIN(IF(A1:A10>0,A1:A10)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "perplexed" <perplexed@discussions.microsoft.com> wrote in message news:C9BDDD7F-294D-4EDC-90AE-DB46AB24D518@microsoft.com... > I am trying to analyze a large block of data where not all columns have an > entry. I want to find the lowest value (but greater than zero or a blank > cell) and write it into a separate column.     Was this post helpful to you?         Reply |   Top           Biff 3/9/2006 2:35 PM PST   Answer   Hi! Try this: Entered as an array using the key combo of CTRL,SHIFT,ENTER: =MIN(IF(A1:C5>0,A1:C5)) Biff "perplexed" <perplexed@discussions.microsoft.com> wrote in message news:C9BDDD7F-294D-4EDC-90AE-DB46AB24D518@microsoft.com... >I am trying to analyze a large block of data where not all columns have an > entry. I want to find the lowest value (but greater than zero or a blank > cell) and write it into a separate column.     Was this post helpful to you?         Reply |   Top           perplexed 3/10/2006 6:04 AM PST   You guys rock! The formula works perfectly and will save me hours of manual searching (and worry that I did it right). The worksheet is already at column AO and growing wider. Thanks for your quick response. "Biff" wrote: > Hi! > > Try this: > > Entered as an array using the key combo of CTRL,SHIFT,ENTER: > > =MIN(IF(A1:C5>0,A1:C5)) > > Biff > > "perplexed" <perplexed@discussions.microsoft.com> wrote in message > news:C9BDDD7F-294D-4EDC-90AE-DB46AB24D518@microsoft.com... > >I am trying to analyze a large block of data where not all columns have an > > entry. I want to find the lowest value (but greater than zero or a blank > > cell) and write it into a separate column. > > >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies