I have an excel spreadsheet with 5762 records. I have used conditional formatting to highlight the cells containing duplicates values. I need to then add those duplicates up.
IE:
ID BAL
1 10
1 10
I need to figure out a way to add the balances together based on them being the same id# if thats even possible. I sorted my sheet out by cell color and I have a thousand or duplicates highlighted. I have been manually going to the cells and doing =sum(i1,i2)
Any help would be greatly appreciated, I have a feeling I will be getting more data with the same problem I am facing now.
Bookmarks