VLOOKUP for duplicates

I made a sheet for fantasy basketball. In one sheet, I have one giant list of players position, player names, and their fantasy points over the last 15 days. A shortened version of it looks like this:
Pos Name Points
C DeMarcus Cousins 39.57
C Dwight Howard 37.58
C Spencer Hawes 36.14
C Nikola Vucevic 33.44
C Andre Drummond 31.78
PF Carmelo Anthony 45.13
PF Anthony Davis 41.85
PF Blake Griffin 40.91
PF Pau Gasol 37.14
PF Dirk Nowitzki 37.03
PG Chris Paul 44.16
PG John Wall 41.97
PG Stephen Curry 41.21
PG Michael Carter-Williams 41.2
PG Ty Lawson 38.35
SF LeBron James 44.06
SF Kevin Durant 42.89
SF Paul George 35.27
SF Rudy Gay 33.44
SF Martell Webster 32.73
SG James Harden 36.4
SG Monta Ellis 35.51
SG Arron Afflalo 35.41
SG DeMar DeRozan 34.29
SG Dwyane Wade 34.24

In the other sheet I'd like to return the top 3 players for each position. My first thought was to do a VLOOKUP, lookup the position, then just return the top 3 players. I'd do this separately for each position. So for example, my thought was vlookup "PF", drag down 2 cells, and get "Carmelo Anthony, Anthony Davis, Blake Griffin." Of course doing that just returns the top player, Carmelo Anthony, 3 times. How do I return the top 3 players by position? I can't just do "=" because the location of the cells change daily.

See: http://windowssecrets.com/forums/sho...l=1#post734296
http://www.techsupportforum.com/foru...ml#post2567119

Hi,

sure there are better solutions

In column A positions, in column B names, in column C points

Please Login or Register  to view this content.

to be copied down in order to get second, third...rank for C position.




Regards

edit: I strongly agree with etaf: Pivot is the most convenient solution.

i would use a pivot table to show top3 by position
and make sure the data is setup as a TABLE , then as you add information it will be included in the pivot table on a refresh

also any change in the data will be seen in the pivot table following a refresh

so i have filtered by name to get TOP10 and then set that option to top3
and also sorted points descending

see attached example

your welcome