REPEATING NUMBERS IN A ROW

[nazzoli]

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.

[Dave F]

=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.
>
>