Min > 0

[Samkillian]

Is there a way to use the Min function to look at a range with zero's included, but ignore them. I'm trying to create a sheet where i am figuring out a price, but i need to compare it and have it no less then the min of our top selling products. Unfortunately, our top products don't sell in all markets and zero's are possible. Thx

 

[jeffreybrown]

Sam,

See if this works for you. Enter the formula with Ctrl+Shift+Enter. If done correctly you will get the {} brackets.

Excel Workbook
	L
9	1
10	2
11	3
12	4
13	5
14	6
15	7
16	0
17
18	1
Sheet7

 

[barry houdini]

You can use an array formula like this

=MIN(IF(A1:A100>0,A1:A100))

confirmed with CTRL+SHIFT+ENTER

...or non-array

=SMALL(A1:A100,COUNTIF(A1:A100,0)+1)

 

[Samkillian]

Awesome, worked great. Thanks.