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

J

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!!!
[email protected]
 
W

William

Hi Jacob

=max(1:1)

--
XL2002
Regards

William

[email protected]

| 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!!!
| [email protected]
|
|
 
Top