Use a pivot table, where both the row and data fields are given the list of unknown repeating
values.

HTH,
Bernie
MS Excel MVP


"Kblue74" wrote in message
...
Looking for a way for excel to count unknown repeating values and create a
summary of those repoeating occurences in a column.