I have an excel list column A has the person ids, column I has a text string of AM or PM I want to add a formulas to the end column (M) to count the number of times AM appears in the AM column for each person id so for example id A09356 is repeated in Column A 100 times it then changes to A09513 I want the formula to count the number of AM entries for A09356 then when this changes to A09513 calculate how many AM entries for A09513 and so on.
I have attached a file