Hi,
I have 3 coloums A B C - if the first two columns match (A4 and B4 for example (horizontal matching)) I would like any duplicate matching rows (A and B) to sum the value in the third column (C) then delete the duplicate row
I have attached a copy of dummy data (sheet 1) and the desired results (sheet 2) in an excel spreadsheet below and copied here too
Sheet one (I have highlighted a duplicate row for example, which would then form one row with column C equalling a value of 3,000)
A B C
0201 25.455_FRA 3,295,872.00
0204 25.455_FRA 0.00
0220 25.455_FRA 0.00
0250 25.455_FRA 2,926.10
0250 25.455_FRA 73.90
0201 25.455_FRA 128.00
0201 25.455_FRA 0.00
0201 25.216_FRA_RD 0.00
0201 25.216_FRA_RD 1,511,892.30
0201 25.460_GBS 1,466,076.25
0250 25.460_GBS 1,066.98
0250 25.460_GBS 33.02
0290 25.460_GBS -45,298.81
0290 25.460_GBS -701.19
0290 25.216_FRA_RD 769.14
0290 25.455_FRA -83,527.82
0237 25.455_FRA 0.00
0290 25.216_FRA_RD 115,230.86
Sheet two
A B C
0201 25.455_FRA 3,296,000.00
0201 25.216_FRA_RD 1,511,892.30
0201 25.460_GBS 1,466,076.25
0204 25.455_FRA 0.00
0220 25.455_FRA 0.00
0237 25.455_FRA 0.00
0250 25.455_FRA 3,000.00
0250 25.460_GBS 1,100.00
0290 25.216_FRA_RD 116,000.00
0290 25.455_FRA -83,527.82
0290 25.460_GBS -46,000.00
Many Thanks
Bookmarks