What makes this difficult is that your data is in multiple columns. Are
there any empty/blank cells within the range? Are both lists of data the
same length?

--
Biff
Microsoft Excel MVP


"Landon Cornett" <Landon wrote in message
...
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.