Excel Magic Trick 1303

Minimum Value Greater Than Zero (3 Examples)

DESCRIPTION

Learn how to to create three different formulas to calculate minimum value greater than zero:
(00:13) Introduction
(01:00) Before Excel 2010: =MIN(IF(C4:T4 greater0,C4:T4))
(03:05) Excel 2010 – 2013: =AGGREGATE(15,6,C4:T4/(C4:T4 greater0),1)
(04:53) Excel 2016 or later: =MINIFS(C4:T4,C4:T4,” greater0″)

WORKBOOKS

Download “Excel Magic Trick 1301-1320” Excel-Magic-Trick-1301-1320.zip – Downloaded 62 times – 285 KB




Be the first to comment

Leave a Reply