copy values and Countif
 

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?

copy values and Countif
 

The easiest method is to use a pivot table. Next to that, a filter
method would work. Otherwise, a macro could delete data from the tally
sheet and add what you wanted then.

For the last 2 methods using =countif, you would use it like this:
=COUNTIF(A:A,A1)


--
Kenneth Hobson
------------------------------------------------------------------------
Kenneth Hobson's Profile: http://www.thecodecage.com/forumz/member.php?userid=413
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105852

copy values and Countif
 

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?