Generate Top 10 Using 3 Columns Specific To Location

[ExcelNoob_111]

Good Day.

I need assistance generating a Top 10 ranking using 3 columns specific to location. I would like for the results to show the Top 10 for each location after a data refresh on a daily basis. At this time, the data table (Name/Location/Total Points) which is located on another tab of a large workbook is refreshed using a macro. The points are accumulated on this tab after manual entry of activities performed on another tab. Once I refresh the data, this list will perform an update and order all of the performers from highest to lowest (adding all of their activity points). I would like to take this list and break it down by location, instead of everyone in one list. I'm at a loss as to how to develop a formula to look at the location column to develop a list using the points and name. If a dropdown feature is possible to create a top 10 list for "X" location, that would be suffice. But having a standard top 10 list based on location will do (maybe through a VLOOKUP).

Also, is there a way to avoid duplication of points in one location that one name would be ignored, but to bump it down one spot (either alphabetically, or by some other criteria)? I've encountered issues with duplicated points but only one name was chosen and the other ignored, not even listed.

Mind you, this list is only a sample size, there are close to 200 names, and possibly growing, but I can just change the range if I were to get a working formula.

If possible, the end result should be a separate Top 10 for Main, Tier 1, Tier 2, and Urban.

Or is this too complicated for a common formula and a macro may be needed?

Book1
	B	C	D
3	Name	Location	Total Points
4	Wayne	Urban	7
5	B.T.	Main	52
6	Oleksei	Urban	891
7	Wade	Main	86
8	Vlad	Main	568
9	Jeff	Urban	219
10	Victory	Main	21
11	Yoshii	Tier 2	598
12	Brian	Main	659
13	T.K.	Main	512
14	Takeshi	Tier 1	9
15	Kurt	Main	51
16	Valentino	Main	14
17	Abdul	Urban	96
18	Mike	Urban	27
19	Sonny	Main	36
20	Tommy	Main	25
21	Paul	Urban	83
22	Pete	Main	47
23	Robert	Urban	55
24	Dennis	Main	43
25	Sean	Tier 2	10
26	Jean	Urban	8
27	Archie	Main	137
28	Kenny	Main	26
29	Paco	Tier 2	55
30	T.M.G.	Tier 2	7
31	Simone	Main	533
32	Rosita	Tier 1	91
33	Mia	Tier 2	25
34	Sonya	Tier 1	846
35	Pierre	Tier 2	219
36	Terri	Tier 2	81
37	Ryan	Urban	51
38	Prisha	Main	63
39	Sven	Tier 2	46
40	Acura	Tier 1	91
Sheet1

Thanks to any and all whom may be of assistance.

 

[ExcelNoob_111]

Then why didn't you say so, rather posting a sheet showing all the columns?

Are you going to be making any other changes, or is this it?

My apologies. This is the last request for a change.

 

[Fluff]

Ok, how about

=LET(s,SORT(FILTER(B4:F40,(IF(H3="",1,C4:C40=H3))*(IF(I3="",1,D4:D40=I3))*(IF(J3="",1,E4:E40=J3)),""),5,-1),INDEX(s,SEQUENCE(MIN(ROWS(s),10)),{1,5}))

 

[ExcelNoob_111]

Ok, how about

=LET(s,SORT(FILTER(B4:F40,(IF(H3="",1,C4:C40=H3))*(IF(I3="",1,D4:D40=I3))*(IF(J3="",1,E4:E40=J3)),""),5,-1),INDEX(s,SEQUENCE(MIN(ROWS(s),10)),{1,5}))

My gratitude. I appreciate your effort and time put into making this work for me.

This is exactly what I'm looking for.

Thank you very much.

Resolved.

 

[Fluff]

You're welcome & thanks for the feedback.