Top 3 scores
 

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

Top 3 scores
 

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,FA LSE)

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

Mike

"Gilbo" wrote:

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

Top 3 scores
 

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

Vaya con Dios,
Chuck, CABGx3



"Gilbo" wrote:

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

Top 3 scores
 

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

"Mike H" wrote:

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,FA LSE)

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

Mike

"Gilbo" wrote:

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