how do I show 1st, 2nd, and 3rd most repeated non-numeric values?
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?
|