R
richzip
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
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