Excel Forum

Excel Magic Trick 681: Find Smallest Number That Is Greater Than Zero Array Formula

See how to use the MIN and IF functions to find smallest number that is greater than zero in an array formula.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.