| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional statement to return greatest value
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional statement to return greatest value
Charles,
Thanks you very much. It actually was that simple. Appricate your help. Ian "Die_Another_Day" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return value in table associated with next greatest | Excel Worksheet Functions | |||
| using a IF statement to return a value | Excel Worksheet Functions | |||
| return the greatest value in a range of cells | Excel Discussion (Misc queries) | |||
| Conditional Formatting Recognizing Greatest Value | Excel Discussion (Misc queries) | |||
| in excel conditional formatting find the greatest value in 4rows | Excel Worksheet Functions | |||
Hybrid Mode
