Forum Discussion
Solved
Get total sales per customer
I have an excel spreadsheet of sales for the last couple of years. Is there a way to merge the individual customer's sales to remove the duplicate listing of the customer but retain the total sales f...
You probably already have an answer but I found a good solution and thought it might help others.
Use the Consolidate feature on the data tab.
Good video here https://www.youtube.com/watch?v=IGaq_biQ1B8
You probably already have an answer but I found a good solution and thought it might help others.
Use the Consolidate feature on the data tab.
Good video here https://www.youtube.com/watch?v=IGaq_biQ1B8
Teresa1810 Thanks for the tip. Was very helpful.