View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
claude jerry claude jerry is offline
external usenet poster
 
Posts: 70
Default How to get name of Salesmen selling highest

HI please help me

I have a file in col A I have names of salesmen and col B how mush they sold

A 100
B 25
C 150

=Max(range) gives me the highest value i.e. 150

i want the name of the salesmen selling the highest eg Mr. C

can it be done