L
Linda Freeman
I have numbers in Columns A thru L, Row 2. I would like
to extract the largest number and return it to Cell M2.
to extract the largest number and return it to Cell M2.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy Brown
MAX returns the largest value in a set of values, therefore
=MAX(A2:L2)
Rgds,
Andy
=MAX(A2:L2)
Rgds,
Andy
V
Voodoodan
Linda,
input the following formula into cell M2:
=MAX(A2:L2)
Dan.
input the following formula into cell M2:
=MAX(A2:L2)
Dan.
T
Tom Ogilvy
If you might later want the second largest number
=Large(A2:L2,1) for the largest
in general
=Large(A2:L2,n) where n would be the nth largest you wanted.
See help for MIN and SMALL as well
=Large(A2:L2,1) for the largest
in general
=Large(A2:L2,n) where n would be the nth largest you wanted.
See help for MIN and SMALL as well
G
George Lin
You can type the formula =MAX(A2:L2) in M2.