Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing totals in 2 column
I have a very large spreadhseet. The spreadsheet looks similar to the one
below. I want to compare the totals (by employee) in column B with the totals (by employee) in column C. If the total in column B is larger, then I want to transfer those values to column D. If the total in column C is larger, then I want to transfer THOSE values to column D. As you can see, for ID 1 ..the total of column C is greater, so those values are carried over to column D. For ID 2 ..the total of column B is greater, so those values are carried over. Since there are a large number of employees, how do I set up a formula to compare these values by employee and make the transfer? Thanks! A B C D 1 ID Sked Act Greater 2 1 5 6 6 3 1 7 5 5 4 1 2 4 4 5 2 3 4 3 6 2 10 2 10 7 2 5 4 5 8 2 6 9 6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing one column of names to another | Excel Worksheet Functions | |||
sum column totals | New Users to Excel | |||
column totals | New Users to Excel | |||
Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |