Aggregate function ignoring 0

[Shiro26]

Hello,

Is there a possibility to use the aggregate function such as the below and ignore a certain values (in my case 0) of the range investigated?
=Aggregate(5,4,range)

Thank you in advance.

Shiro

 

[StephenCrump]

You could use: {=MIN(IF(range<>0,range))} array-entered

 

[Shiro26]

You could use: {=MIN(IF(range<>0,range))} array-entered

Hi

thank you
I wanted to avoid using array formulas but it seems that it is the simplest way.
The below works as well
=AGGREGATE(15,6,(1/((range<>0))*range),1)

Thank you
Shiro

 

[Aladin Akyurek]

Try MINIFS if your system contains it...

=MINIFS(range,range,">0")

By the way, one should also ignore the negatives.

 

[Shiro26]

Try MINIFS if your system contains it...

=MINIFS(range,range,">0")

By the way, one should also ignore the negatives.

Hi,
Thank you for your message,
I have never seen that. Where is that function coming from?

Thank you inadvance

Best,
Shiro

 

[Aladin Akyurek]

Hi,
Thank you for your message,
I have never seen that. Where is that function coming from?

Thank you inadvance

Best,
Shiro

The newer versions of Excel (some Excel 2016 versions) contain this function...