I am trying to create a top 5 list of the most frequent values from a range. I know how to use the MODE function to get the most frequent number in a range, but I want to find the most frequent text...as well as get the next 4 most frequent. For example...
My range would be a1:a16 and I need a formula to place into d2 for the most frequent non-numerical value in the range, d3 for the second most frequent and so on...
ANY help would be greatly appreciated, excel newbie here
My range would be a1:a16 and I need a formula to place into d2 for the most frequent non-numerical value in the range, d3 for the second most frequent and so on...
ANY help would be greatly appreciated, excel newbie here