Top 3 scores

G

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),
 
M

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top