Use CountIf with reference to Col A for the Criteria, then use a data filter
advanced unique to get your list.

"mattg" wrote:

I have a worksheet with multiple repeating values in column A. I would like
to find a way to copy the values just once per occurence to another worksheet
and then tally next to it the number of times the value appears in the
original worksheet.

So if "Fred" appears in column A 12 times and "Joe" appears 15 times I would
to produce a sort of summary sheet that says
Col A ColB
Rw1 Fred 12
Rw2 Joe 15

I understand the "Countif" but what if the values you're counting change
from day to day?

Any thoughts?