Extract data from sheet and count

[rschoenb]

Hi,

I am going to try and explain what I am trying to do but I am not sure how to do this. I have a spread sheet which has "reporter" which is a person who is opening a case. There maybe be duplicates because the person may open many cases. What I am trying to do is count the individuals and only report on the top 10 who opened cases based on a specific priority. I don't really want to use a pivot table because this may not really give the information in the format I wish.

I've attached a sample but there are no formulas because I am honestly not sure how to pull out and place names within fields as well as count.

Thank you,

Ruth S.