Forum Discussion
Summing data if date in another column is duplicated and removing unneccessary data
Roksana Ooops! just realized that the dates are not synchronized between customers on one side and Calls and Emails on the other. Better to create a table with one Date column and then summarize with a pivot table.
Edit: Alternatively, use Power Pivot or Power Query. Attached a file that contains three different solutions, all leading to the same end result.
Roksana Consider using a Pivot Table as demonstrated in the attached file.
That's brilliant! I haven't thought about it, thank you so much!
Roksana Ooops! just realized that the dates are not synchronized between customers on one side and Calls and Emails on the other. Better to create a table with one Date column and then summarize with a pivot table.
Edit: Alternatively, use Power Pivot or Power Query. Attached a file that contains three different solutions, all leading to the same end result.
Yeah, I've only included one date column in my table, and it worked perfectly. Thanks again!