ExcelBanter - lowest number in a set EXCLUDING zero

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - lowest number in a set EXCLUDING zero (https://www.excelbanter.com/excel-worksheet-functions/117470-lowest-number-set-excluding-zero.html)

Bad Kitty

lowest number in a set EXCLUDING zero

I'm trying to figure out which formula to use to find the lowest value (all
numbers) in a range excluding zero. I've tried MIN, MINA and DMIN, which I
think is the correct one....but I'm not sure how to set the criteria to 0

Thanks for any help

^..^<

Duke Carey

lowest number in a set EXCLUDING zero

This is an array formula, entered by pressing Ctrl-Shift-Enter

=MIN(IF(A1:A30,A1:A3))

"Bad Kitty" wrote:

I'm trying to figure out which formula to use to find the lowest value (all
numbers) in a range excluding zero. I've tried MIN, MINA and DMIN, which I
think is the correct one....but I'm not sure how to set the criteria to 0

Thanks for any help

^..^<

JMB

lowest number in a set EXCLUDING zero

A non-array approach I saw Harlan Grove use:

=SMALL(A1:A7,COUNTIF(A1:A7,"<=0")+1)

"Bad Kitty" wrote:

I'm trying to figure out which formula to use to find the lowest value (all
numbers) in a range excluding zero. I've tried MIN, MINA and DMIN, which I
think is the correct one....but I'm not sure how to set the criteria to 0

Thanks for any help

^..^<

All times are GMT +1. The time now is 11:43 PM.