Like the MIN function, the MINA function returns the smallest numeric value in a supplied set of data. For example, the MINA function can return the lowest test score, the fastest time in a race, the lowest temperature, or the smallest sales number. Arguments can be provided as constants, or as cell references or ranges:
The primary difference between MIN and MINA is that MINA evaluates TRUE and FALSE values as 1 and 0 respectively. Microsoft documentation also suggests that MINA evaluates numbers entered as text differently from MIN:
If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.
This is a bit confusing. In my testing, MIN and MINA both evaluate text representations of numbers when supplied directly as arguments. For example:
=MINA("5",10)// returns 5=MIN("5",10)// also returns 5
The difference appears to be that when text values exist in a cell reference, MINA evaluates them as zero in the calculation, whereas MIN simply ignores them. For example, if A1 contains "5", and A2 contains 10:
The Excel SMALL function returns numeric values based on their position in a list ranked by value. In other words, it can retrive "nth smallest" values - 1st smallest value, 2nd smallest value, 3rd smallest value, etc.
The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time) values, using an...