Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
If statement or lookup statement not sure | Excel Worksheet Functions | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions |