Yeah, this a bit of a pain. You have to do the counting manually. Create a formula which splits the string apart and then loop the array and count how many times each element appears. In fact, you're going to have to create a new array that tracks these counts. Put this in a shared variable. After that, you can have a formula that just returns one element from the array. You could also create a function which is passed the element number and it returns the count and text for each element. Anyway, this is going to take a bit of coding and some expertise to pull off. But I don't see any other way.

Thanks for the input.  Both your suggestions work with the exception that some of the data sets have more then one entry, such as WH1,AM1.