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 year, that shows how many orders a customer has each month.
Report with formula that's not working.
- 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!I receive an "Unauthorized Error 401" when clicking that link.
Unless I'm mistaken, it would appear that you're displaying the desired report, not the dataset from which it is to be generated.
Unless the data is highly confidential--and if it is, perhaps you could create a copy without the actual names of products or customers--it would help us help you if you could post not just an image, but the actual workbook. Put it on OneDrive or GoogleDrive with a link here that grants access to it.
Here is a sample file.
Thanks for your help!
