Returns largest number

[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.

 

[Andy Brown]

MAX returns the largest value in a set of values, therefore

=MAX(A2:L2)

Rgds,
Andy

 

[Voodoodan]

Linda,

input the following formula into cell M2:

=MAX(A2:L2)

Dan.

 

[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

 

[George Lin]

You can type the formula =MAX(A2:L2) in M2.