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...
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!
