Hi,
I am new to this forum but hoping someone can still help. I have a set of data that I need to be able to create subtotals from. The issue is that some of the data is duplicated yet it is correct. An example is below
Current data format
item1 100
item1 150
item1 100
item2 100
item2 100
item1 100
item1 100
Required Output
item1 350
item2 200
item1 200
My initial thought was some form of Do until loop that contains a Sum. For instance it would sum item1 numbers (350) until it gets to item2. At which point it would add it at the bottom of the sheet as a subtotal shown above in the Required Output. I would need to the macro to then do this for item2 and item1 again.
My issue with just using a cell formula of a sumif is that adds all of item1 together and can't distinguish it.
I hope someone can help with this,
Many thanks for reviewing,
Adam
Bookmarks