Thread: Top 3 scores
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gilbo Gilbo is offline
external usenet poster
 
Posts: 10
Default 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),