contacts counts as 1 contact, appointments counts as 1 contact and 1 appointment, estimate, 1 cont 1 app and one estimate. The sales count as 1 cont 1 app 1 estimate and ons sale.
What I would like to do, lets say, if I count all the 2s in coulm a, then in cell b1 b2 it must show one cont and 1 appointment, and so on if I count all the 3 in coulm a then b1, b2 and b3 will all have a 1 in them.
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site or http://wikisend.com/ post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like