Skip to Main Content
Microsoft Excel Functions & Formulas
book

Microsoft Excel Functions & Formulas

by Bernd Held
September 2006
Beginner to intermediate content levelBeginner to intermediate
397 pages
13h 15m
English
Jones & Bartlett Learning
Content preview from Microsoft Excel Functions & Formulas
Use the ADDRESS, MATCH, and MAX functions
to find the largest number
We learned in previous tips how to look up a single value in a list.
Now we want to determine the position of the largest value in a list
by combining three Excel functions. First, we use the MAX func-
tion to get the largest value, then we use the MATCH function to
find its relative position, and finally we use the ADDRESS function
to determine the exact cell address.
Note: The MAX function was described in Chapter 5.
MATCH(lookup_value, lookup_array, match_type)
lookup_value: The value that corresponds to the entry to be
found in a table.
lookup_array: A contiguous range of cells that ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel - Advanced Formulas And Functions

Microsoft Excel - Advanced Formulas And Functions

Guy Vaccaro

Publisher Resources

ISBN: 9781598220117