Hello All,
Is there a formula which will look into the Data Dump Tab and match from the Table Tab the Sold Mgr Name and Product listed under them in between the dates on top from the Table tab to the Data dump Table and return the account count from column A in the Data dump Tab. But it won’t count the account multiple times.
Example if John sold a Notebook to Walmart, RiteAide, and Homedepot between 2016-01 to 2016-12 it should count Walmart, RiteAide, and Homedepo as 3 regardless if he sold a Notebook on 2016-02 and again 2016-06 and again 2016-09 and again 2016-12 for each account.
In the attachment I’ll added what the answer should be for John if formula created works. The formula should work for the other Sold Mgr Names as well with just adjustment picking one of the other Sold Mgr Names.
I’ve also put another tab with a different view of the Chart but it would be the same as the Table tab result if it would be easier to understand that view for you.
I know the formula has to deal with Sum if of countif and with frequency.
See attachment.
I would greatly appreciate the help.
Thank you,
Bookmarks