=MAX(A1:E1) would return 215 in F1

"nazzoli" wrote:

I have a spreadsheet that goes on for several thousand lines. It looks like
this:

A B C D E

100 15 215 6

1 10 25 32

What I am looking for is a forumla or something that will put in another
column the highest of the 5 values. So for example, row 1 the highest value
215 will be placed in column F.