Determine the nyumber of times a value appears in an Excel column

I have a column of duplicate values that I need to determine how many times each value appears.  In column A i have a list of values (names), in column B I would like the number of times that name appears in the list to appear as a number.  So if the name PETER appears 10 times in a list of 100 names, I would like the number 10 to appear next to Peter's name each time in column B.  Is there a formula to do this?
marku24Asked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
In cell A2:

   =COUNTIF(A:A,A2)

copy down as far as needed.

Kevin
0
 
leonstrykerCommented:
CountIf function should do that for you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.