View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
it''sh hardy it''sh hardy is offline
external usenet poster
 
Posts: 1
Default Formula To Show Which Cell Has The Highest Rate

I work for a retail company and am trying to get the formula to show which
location has the highest rate. For instance - Brandon has 25 sales, Tampa has
30, and Clearwater has 50. This formula would automatically determine which
store has the highest and show up in RED saying BIGDOG!

Any help is better than what I have lol!

Thanks!