Microsoft Office Tutorials and References
In Depth Information
The MAX function returns the largest value in a set of values. The argu-
ments number1, number2, ... are one to 255 numbers for which you want to find
the maximum value. The remaining rules are similar to those for MIN, de-
scribed in the preceding section.
Finding a Minimum Text Value
Finding a Minimum Text Value
If you read the descriptions for MINA and MAXA, you might think that
the functions can be used to find the smallest text value in a range.
However, here is the Excel Help description for MAXA:
MAXA(value1,value2) returns the largest value in a list of arguments.
Text and logical values such as TRUE and FALSE are compared as well
as numbers.
The problem, however, is that text values are treated as the number 0 in
the compare operation. It is a struggle to imagine a scenario where this
would be mildly useful. If you have a series of positive numbers and
want to know if any of them are text, you can use =MINA(A1:A99). If the
result is 0, then you know that there is a text value in the range.
Similarly, if you have a range of negative numbers in A1:A99, you could
use =MAXA(A1:A99). If any of the values are text, the result returns 0
instead of a negative number.
MINA and MAXA could be used to evaluate a series of TRUE/FALSE val-
ues. FALSE values are treated as 0. TRUE values are treated as 1.
Values in a List of Values
The MAX function discussed in the preceding section finds the single largest
value in a list. Sometimes it is interesting to find the top 10 values in a list.
Say that with a list of customer receivables, someone in accounts receiv-
able might want to call the top 10 receivables in an attempt to collect the
accounts. The LARGE function can find the first, second, third, and so on
largest values in a list.
LARGE to Find the Top
to Find the Top N Values in a List of Values
Search JabSto ::

Custom Search