ExcelBanter - REPEATING NUMBERS IN A ROW

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - REPEATING NUMBERS IN A ROW (https://www.excelbanter.com/excel-worksheet-functions/105575-repeating-numbers-row.html)

nazzoli

REPEATING NUMBERS IN A ROW

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

REPEATING NUMBERS IN A ROW

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

All times are GMT +1. The time now is 09:53 AM.