Extract data from sheet and count

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.

Formula:

Please Login or Register  to view this content.

in your sample Raven should be 3 not 4 since the other is priority P2

Ruth, you need to title your thread with something that describes your problem, not what you thing the answer should/might be

Originally Posted by rschoenb

Sorry about that FDibbins.. I would change if I could next time I will be more specific.

For future reference, to change your thread title, go to your 1st post, click EDIT POST (next to Reply), then scrll down a bit to fine Advanced, then change your title there

I have changed it for you - this time

Thanks

How many names do you expect to have - your sample has 3. Do you only what max 10 shown, and if so, which 10?

I put my formulas to the side of yours in column E (Count) and F (Name)

	B	C	D	E	F
1	Case Count	Top Reporter	Priority
2	4	Cindy Cole	P3	4	Cindy Cole
3	4	Raven Moore	P3	3	Raven Moore
4	2	Sean Meek	P3	2	Sean Meek
5
6

E2=COUNTIFS(Cases!E:E,Summary!F2,Cases!F:F,Summary!D2) copied down

F2=IFERROR(INDEX(Cases!$E$2:$E$11,MATCH(0,INDEX(COUNTIF($F$1:F1,Cases!$E$2:$E$11),0,0),0)),"") copied down

You could put P3 in its own cell and reference that, to give you more flexibility