Top 3 scores

[Gilbo]

I have a spreadsheet with columns A - Teams, B - HomeScore, C - AwayScore. I
want find how do i find the top three scores in homescore and also pick the
relivent info from column A & column C. I can find the top 3 scores with
LARGE(B4:B93,1),LARGE(B4:B93,2),LARGE(B4:B93,3),

 

[Mike H]

Hi,

For the team
=INDEX($A$4:$A$93,MATCH(LARGE($B$4:$B$93,ROW(A1)),$B$4:$B$93,0))

fpr the away score
=VLOOKUP(LARGE($B$4:$B$93,ROW(A1)),$B$4:$C$93,2,FALSE)

Drag each of the formula down 2 rows and you get the team/away score for the
2nd and 3rd largest

Mike

 

[CLR]

Data > Filter > Autofilter > then click the downarrow on column B and choose
"Top 10" and reset for 3

Vaya con Dios,
Chuck, CABGx3

 

[gil_wilkes]

Thanks for that, it works fine. What I want now is that in column D I have
AwayTeams and i need to bring the away team up relevent to HomeTeam and the
scores