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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - this should be easy...highest value in a row (https://www.excelbanter.com/excel-discussion-misc-queries/3482-should-easy-highest-value-row.html)

jacob farino

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

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!!!

Jason Morin

=MAX(1:1)

HTH
Jason
Atlanta, GA

-----Original Message-----
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!!!

.

Ron Rosenfeld

On Tue, 11 Jan 2005 00:11:27 GMT, "jacob farino"
wrote:

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!!!

=MAX(1:1)

--ron

All times are GMT +1. The time now is 04:47 AM.