I have 2 columns; one for product and one for date. The product column (text) includes 6 different products, and the date column (mm/dd/yyyy) lists when they were sold.(NOTE: there is a 3rd column which includes exact time product was sold, but that information is not part of this question.) So I have multiple occurrences where the product in column A matches the date in column B.
I'm looking to truncate this information by month and by product into a nice table for visualization. I need to build an equation that counts how many of each product was sold in each month.
My master list is enormous, so anything to keep this automated would be appreciated. Thanks in advance.
Bookmarks