I have a sorted list and would like to find out how many times each name in a column appears. Is there a way to have excel take each name that appears in the column and then show it once and how many times in appears in the column. For example there are many johns, peters and sarahs in the list. I want excel to say john appears 30 times, peter, 200 and sarah, five. I want it to do it for each unique name in the list even if it appears only once. thanks.Lance