View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Landon Cornett Landon Cornett is offline
external usenet poster
 
Posts: 1
Default Tracking High Frequency Occurences

I am trying to track the most frequently occurring statements on a sheet.
For example:

Column A Column B
People Apples
People People
Places People
Apples People
Oranges Places
Bananas Places

I need to track the top 3 occurences, so in this circumstance, I would want
the output at the bottom of the screen to read:

Trends:
People
Places
Apples

Any help would be appreciated.