Formula for multiple distinct values & numbers of those values?

[ArPharazon]

I may be explaining this badly, which is probably why I haven't been able to come up with anything on Google for this.

I run a report every day for my job that I'd like to use a formula on that shows each distinct text value from a column and then how many instances of each there are.

At least I hope it can be done with a formula

Below is a generic example. What I'd like to end up seeing is: Name1 | 10 / Name2 | 6 / Name3 | 4 and filter out #N/A if possible. The values in this column are all the result of a vlookup.

 

[ArPharazon]

I used $K$411:$K411 the first time around but tinkered with it and it's in there now, with the same results.

I get the first "name" that appears in column K and a 3 which should be a 2 (assuming =IF(K412="","",COUNTIF(K:K,K412)) is correct)

 

[Eric W]

Since you're putting the unique list below the source list (which is a bit unusual), you need to change the COUNTIF formula to:

=IF(K412="","",COUNTIF(K$2:K$409,K412))

otherwise it counts the value in the unique list too.

 

[ArPharazon]

Since you're putting the unique list below the source list (which is a bit unusual), you need to change the COUNTIF formula to:

=IF(K412="","",COUNTIF(K$2:K$409,K412))

otherwise it counts the value in the unique list too.

Gotcha! That one I should've seen. As far as getting all of the names to display instead of just the first one, what am I doing wrong there?

It seems not to like working with =vlookup values, but if I paste the values into another column it appears to work.