| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i show non-numeric values graphically in a chart? | Charts and Charting in Excel | |||
| can i show repeated values in a pivot table? | Excel Discussion (Misc queries) | |||
| Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
| Repeated values in a row | Excel Discussion (Misc queries) | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Threaded Mode
