Hi,

If you want it row by row put this in E1 and drag down

=MAX(A1:D1)

If you want the maxh of the entire array in one formula use this

=MAX(A1:D3)

Mike

"Gary F Shelton" wrote:

Need some help writing a formula

Column A Column B Column C Column D Result
Return
500 652 450 710
710
850 200 50 354
850
620 892 100 400
892

My goal is to write a formula that will return the larges volume within
Column A thr D. As you can see the largest volume can be in any column/row
intersection.

Regards,
GFS


--
GS