Hi all,
i have an excel report that spits out duplicate values due to the source system.
Need help with a consolidate function that will first scan the data, and then consolidate.
I initially had a loop function that went through the data line by line looking at duplicate policy numbers and consolidating the values if so, but realised it has flaws ( it will consolidate the first 2 lines, and then sum the rest)
Is there some sort of scan function i can use?
Data
Policy
No value
1 10.00
1 10.00
1 10.00
1 20.00
1 20.00
1 20.00
2 30.00
3 40.00
3 40.00
goal result
1 30.00
2 30.00
3 40.00
Bookmarks