Here's the easy way to do this:

Use the Advanced Filter to extract the unique values. Choose to copy those
unique values to another location. Suppose those unique values are copied to
the range A1:A5.

In B1 enter a formula like this:

=COUNTIF(J$1:J$20,A1)

Where J1:J20 is the location of the list with dupes.

Drag copy the formula in B1 down to B5.

Then sort A1:B5 on column B descending.

Biff

"dboy" wrote in message
...
I have several categories that are repeated numerous times. For example,
most eaten fruit in the cafeteria... apples, oranges, bananas...

I want to put in a formula that will count how many times each fruit is
repeated in the data, and if apple is top repeat, show apple in the
cell...

Then if banana is second I want to show banana in the next cell. etc.???
Any help?