Question Details

Browse

Finding the smallest non-zero number in a list in Excel?

By Chuck Berry - Oct. 05, 2009

Does anyone know how I can find the smallest non-zero number in Excel using a formula. I've used the MIN function, successfully, on multiple occasions and could use it in combination with the IF function but it is kludgy and requires adding additional columns, etc.

TIA for your help


Answers

Add Answer

  1. By Dawn Giorgio on Oct. 05, 2009

    From the microsoft site:


    The Microsoft Excel MIN function returns the smallest number in a list of arguments. If the smallest number is zero (0), the function returns zero.


    To return the smallest number greater than zero, enter the following array formula

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

    where A1:A10 represents the range of the numbers. This returns an array of a single value with the smallest positive number.


    NOTE: To enter an array formula in Excel for the Macintosh, press COMMAND+RETURN.


    0 Votes
    Report this
Share your knowledge

Related Questions

Browse Get answers and share your expertise.

Open Source Business Intelligence/Reporting Tools?

By Julio Dominguez - Jun 18, 2008
4 answers