Determine the nyumber of times a value appears in an Excel column
Posted on 2011-04-28
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?