IF STATEMENT HELP
What I have, some duplicate ID's and some non-duplicate ID's. Need to sum the
amount from two rows and identify the duplicate record in a new column
ID Hours Qtr Gross Qtr
00293 0.50 30.50
00337 170.40 10,574.39
00337 124.00 7,642.49
00443 190.25 12,131.18
00443 132.00 8,140.27
00467 14.00 854.05
00467 3.00 184.27
00913 710.75 45,124.94
00913 166.00 10,242.38
01234 3.55 220.18
What I want
ID Hours Qtr Gross Qtr Grand Total Gross By ID
00293 0.50 30.50 30.5
00337 170.40 10,574.39 18216.88
00337 124.00 7,642.49 Duplicate
00443 190.25 12,131.18 20271.45
00443 132.00 8,140.27 Duplicate
00467 14.00 854.05 1038.32
00467 3.00 184.27 Duplicate
00913 710.75 45,124.94 55367.32
00913 166.00 10,242.38 Duplicate
01234 3.55 220.18 220.18
Any suggestions?
|