Hi All,

Col A5:A? conatins names of clients that repeat over time, Col B contains
codes " BW, COL, HC" AND OTHER CODES.

In Col D5:D? is a list of the names in Col A but listed only once, Column
hedding are in: Col E4 is BW, F4 is COL, G4 is HC.
Below each of these heddings next to the name in Col D i want to have a
count of how many times the code appers next to the corresponding name in
Col A.

The codes are intered in Col B like this: BW, HC or COL, BW, HC or HC, BW
or COL and so on, in other words they are entered in any order with a comma
between each code or only a single code only.

Hope this makes some sense.

Thanks,
JK