Hi all, I am unsure if this will be easier if I just used a formula and displayed the results in a cell. But here is what I wish to achive:

In cells D:D, I have a 'loop refrence' which can be A, B, C, D or E. The data is inserted sequentially so A,A,A,A,A,A,B,B,B,C,C,C,C,C. The refrence could finish at any letter, so it may only have two loops, so column D:D may consist of A,A,A,A,A,A,B,B,B,B,B. Hope this is making sence so far.

In loop A, 1 piece of equiptment is stored per cell in column M:M e.g.
A, MAC
A, Smoke
A, Sounder
A, MAC
A, MAC

I want a messagebox to display how many 'MACs', 'Smoke', and 'Sounders' are in each seperate loop. e.g.
Loop A
34 MACs
3 Smokes
2 Sounders

LoopB
2 MACs
6 Smokes
7Sounders

Hope this is clear enough, thanks in advance for any help!