View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nelson Nelson is offline
external usenet poster
 
Posts: 69
Default How do I keep a running 'Top five' in Excel?

I'd like to keep a running 'Top Five' in Excel. Attach names to values, and
list the top five names that the values are attached to.
Eg:
Mike - 5
Steve - 6
At the moment, the top value would be 6, so the cell would display 'Steve'.
But if we add 2 points to Mike, the cell would automatically update to
display 'Mike' as he has a higher value. Is this possible?