Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to look at the data in three fields, determine which is the highest of
the three and then have the highest of the three fields add up in a fourth field. I'll try to type in an example; if a1 is greater than a2 and greater than a3 then a1 needs to be posted into a4, but if a2 is greatest than a2 needs to be posted in a5 and if a3 is greatest it needs to be posted in a6. Hope I didn't confuse you too much! Thanks. Todd. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Compare 2 fields? | Excel Discussion (Misc queries) | |||
how to compare a list of data that is same as the main data sheet | New Users to Excel | |||
how to compare text fields in 2 different columns in excel | Excel Worksheet Functions | |||
How do i compare data fields and assign values? | Excel Worksheet Functions | |||
compare info in 4 worksheets and highlight fields that are the sam | Excel Worksheet Functions |