| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I use MIN function to find lowest, NON-ZERO or blank value?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I use MIN function to find lowest, NON-ZERO or blank value?
=MIN(IF(A1:A100,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" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I use MIN function to find lowest, NON-ZERO or blank value?
Hi!
Try this: Entered as an array using the key combo of CTRL,SHIFT,ENTER: =MIN(IF(A1:C50,A1:C5)) Biff "perplexed" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I use MIN function to find lowest, NON-ZERO or blank value
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:C50,A1:C5)) Biff "perplexed" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a "9" within a range using a function (T/F) | Excel Discussion (Misc queries) | |||
| Find a "9" within a range using a function (T/F) | Excel Worksheet Functions | |||
| find the lowest value in a row and add a number to it | Excel Worksheet Functions | |||
| Find lowest and highest value from a set of rows | Excel Discussion (Misc queries) | |||
| How to find highest, lowest and last cell in row? | Excel Discussion (Misc queries) | |||
Hybrid Mode
