this should be easy...highest value in a row

[jacob farino]

How do you display the highest numeric value in a row?

Example:

Row 1:
A 100 B 200 C 300 D displays "300", highest number on row 1.

lookup value or something????????

thanks!!!
(e-mail address removed)

 

[William]

Hi Jacob

=max(1:1)

--
XL2002
Regards

William

(e-mail address removed)

| How do you display the highest numeric value in a row?
|
| Example:
|
| Row 1:
| A 100 B 200 C 300 D displays "300", highest number on row 1.
|
| lookup value or something????????
|
| thanks!!!
| (e-mail address removed)
|
|

 

[Jason Morin]

=MAX(1:1)

HTH
Jason
Atlanta, GA

 

[Norman Jones]

Hi, Jacob

Try:

=Max(1:1)

1:1 identifying row one.

 

[Ron Rosenfeld]

How do you display the highest numeric value in a row?

Example:

Row 1:
A 100 B 200 C 300 D displays "300", highest number on row 1.

lookup value or something????????

thanks!!!
(e-mail address removed)

=MAX(1:1)


--ron