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

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