View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default conditional statement to return greatest value

MAX(A1:C1)
what's the issue here? I'm sure it's not that simple.
Charles

Ian W. wrote:
hello,
I have several colums containing numerical data. What Im trying to do do is
create another column that will return the highest value for each row. I've
fooled around with conditional statements to try and get this to work but
can't seem to figure it out. Does anyone have any ideas? I'd really appricate
any input. Thanks!
-Ian

example:
column1 column2 column3 "column trying to create"
1 3 8 8
6 2 4 6
5 7 2 7