| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find min() value greater than zero in column of numbers
I'm trying to find a formula that will find the min of a column of numbers
but not include a zero if that is the lowest. I got the min part, but if a zero is there, that is my result. (in Excel 2003). Thx |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find min() value greater than zero in column of numbers
Use your formula like this...
=SMALL(A:B,COUNTIF(A:B,0)+1) Change the cell reference A:B to your desired range, if required. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "82716" wrote: I'm trying to find a formula that will find the min of a column of numbers but not include a zero if that is the lowest. I got the min part, but if a zero is there, that is my result. (in Excel 2003). Thx |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find min() value greater than zero in column of numbers
Another way
Placed in say, B2, array-entered*: =MIN(IF(A2:A1000,A2:A100)) *press CTRL+SHIFT+ENTER to confirm the formula Success? hit the YES below -- Max Singapore xde --- "82716" wrote: I'm trying to find a formula that will find the min of a column of numbers but not include a zero if that is the lowest. I got the min part, but if a zero is there, that is my result. (in Excel 2003). Thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to average a column of numbers that are greater than 0? | Excel Worksheet Functions | |||
| Nested If statement to find greater than but less than numbers | Excel Worksheet Functions | |||
| Using COUNTIF to find numbers within a range greater than the mean | Excel Worksheet Functions | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
| I need to find odd numbers in a column | Excel Worksheet Functions | |||
Hybrid Mode
