| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Most popular items in a list
Hi I am trying to calculate the most popular, then second most popular, then
third most popular tems from a list (the items are numbers 1,2,3,etc) The mode function returns the most popluar item but not the second, third etc. Also, if there is a tie then the lowest value should be returned e.g. 2 is the most popular item, 4 and 7 are the second most popular (joint) so 4 is the second most popular and 7 the third etc |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Most popular items in a list
Create a pivot table:
Make sure there is a header cell ('items") on the top and pull-down Data Pivot Table In the layout tab, drag item to the row area and count of items to the data area. The items with the highest counts will be the most popular and so on down. -- Gary's Student "Eddie" wrote: Hi I am trying to calculate the most popular, then second most popular, then third most popular tems from a list (the items are numbers 1,2,3,etc) The mode function returns the most popluar item but not the second, third etc. Also, if there is a tie then the lowest value should be returned e.g. 2 is the most popular item, 4 and 7 are the second most popular (joint) so 4 is the second most popular and 7 the third etc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking for duplicate items in list | Excel Worksheet Functions | |||
| Numbering items from a list in order | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Making list of items to truck monthly usage | Excel Discussion (Misc queries) | |||
| Indexing items from a pick list | Excel Discussion (Misc queries) | |||
Linear Mode
