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...
It's possible with dynamic arrays (REDUCE or even PIVOTBY, if you're fortunate to have it on insiders) or with a pivot table. Do you happen to have an anonymized sample workbook to share?
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.
