Hi, I hope you can help me with this problem.
I have an excel where I want to remove the duplicates based on column “B” and adding the numbers from column “D”
Column “A” is the day of the month, so knowing this an example would be the following
In this data I would have the following output
DAY , ID , SUM
31 , 5266 , 50422.19
31 , 6178 , 1812.26
now the id will be repeated many times but the day will be different
output
DAY , ID , SUM
30 , 5266 , 37977.24
then the complete output of my file would be the following
DAY , ID , SUM
31 , 5266 , 50422.19
31 , 6178 , 1812.26
30 , 5266 , 37977.24
I hope you can help me, or give me some advice on how to search or what activity to use for this purpose