Forum Discussion
Counting Invoices when there are duplicates
I have a data set that has a listing of multiple invoices with the invoice number repeated because the data also had the product that was sold. I need to generate a report, for each month of the yea...
https://docs.google.com/spreadsheets/d/165W7eVIvqnd0k564R9oN2SoygsU7xJPR/edit?usp=drive_link&ouid=108147926468298512703&rtpof=true&sd=true
Here is a sample file.
Thanks for your help!
Here is a sample file.
Thanks for your help!
I receive an "Unauthorized Error 401" when clicking that link.
Thank you. I've attached a pivot solution.
Thank you for your attempt. This is not what I was looking for.
For instance. Customer D for January, the pivot table shows 7. The answer really is 2. There were only two orders in January. On the 2 orders, there were 7 items.
Any other thoughts?
