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