Jaimee001
Member
Hi there,
I have an excel questions that I'm really racking my brains out over.
I have this report and I can filter it down to about 600 rows. the issue that some of the accounts use more than 1 product. I need to get a count of accounts and their products.
I used conditional formatting but that becomes tricky to count. I tried a pivot but there are so many rows and different products that it get's tricky to count as well
I've attached a mock up of a report. I did a couple of pivot table but still not sure how that would work
I'm not 100% well versed in the countifs formula but if that would work, please let me know. Also, would VB be a good alternative? sorry to keep rambling on but I don't know what to use.
Thank you in advance
I have an excel questions that I'm really racking my brains out over.
I have this report and I can filter it down to about 600 rows. the issue that some of the accounts use more than 1 product. I need to get a count of accounts and their products.
I used conditional formatting but that becomes tricky to count. I tried a pivot but there are so many rows and different products that it get's tricky to count as well
I've attached a mock up of a report. I did a couple of pivot table but still not sure how that would work
I'm not 100% well versed in the countifs formula but if that would work, please let me know. Also, would VB be a good alternative? sorry to keep rambling on but I don't know what to use.
Thank you in advance