View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fanny Fanny is offline
external usenet poster
 
Posts: 21
Default look for text not using vlookup and sum if

Dear Helpers,

I have a long listing below for checking

Name Score
Peter 70
Anna 120
Sam 50
........


I use Max to find the highest score is 120 and I want to use the highest
score to look for the name who gets the highest score.

How to do so,

thanks a lot for your help.

Fanny