How to count multiple matches

[Paul Naylor]

Hi , Hoping someone can help.

I have a raw data file of advisor quality scores . For each period ( P1 - P13) each colleague has 3 manager calls & 2 QA ( for Qa Bonus)calls , but I'm having to classify calls e.g. P1 Call 1, P1 Call 2, P1 Call 3 , P1 Bonus Call 1, P1 Bonus Call 2 which I then combine with the relevant advisor name so than I perform multiple vlooks up , but I'm wanting to automate the process , but struggling to find a formula which do the count functions

Columns A is Period Data P1 - P13
Column B is the Advisor Names
Column C is the Evaluator Type i.e. Mngr or QA
Column D is the formula to combine columns A,B & C ( =IF(C2="QA",B2&" Bonus "&A2&" Call",B2&" "&A2&" Call") e.g. Albert Hall P3 Call ( x 3 occurrences) or Albert Hall Bonus P3 Call X 2 occurrences . Looking for a formula which will count each occurrence either as a combined formula e.g. Albert Hall P3 Call1, Albert Hall P3 Call2, Albert Hall P3 Call3, Albert Hall P3 Bonus Call1, Albert Hall P3 Bonus Call2 ...... or a column that will count 1 for 1st occurance , 2 for 2nd occurance and 3 for 3rd occurances in column D which I can then combine with Column D

 

[Paul Naylor]

Hi All,

No need to reply worked it out ( sometimes obvious are not so obvious

Column E =COUNTIF($D$2:D2,D2) then combine Column D & E