Ok so this is kinda hard to explain but let me try. I have a set of records over 1million long. This is a log sheet of sales. So Col A is Cust ID and Col B is sales date. I need to be able to find out how many months throughout the year each cust ID bought something. So for a small example I have included an attachment that also shows my desired results. Sample data.xlsx
I basically need to find a way to get sumif of the distinct months but I am having a brain fart on how to do that.
Bookmarks