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