Hi
I have a data in two columns, A and B. Column A contains the price and column B contains how many products with that price I have sold.
Ex:
1050 2
950 1
950 1
950 1
1200 2
800 2
800 1
3200 1
1000 1
1000 2
Can you please write a macro that adds the sum of the duplicate prices and adds the number of products that I have sold with that price and removes the duplicates?
The result should look like this
1050 2
2850 3
1200 2
1600 3
3200 1
2000 3
Thank you
Bookmarks