View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nazzoli nazzoli is offline
external usenet poster
 
Posts: 17
Default 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.