Example File:
Monthly Stats Example.xlsx
Hi,
Long time lurker, first time poster. I have been asked to produce a stat sheet for my company and have come across an issue trying to generate the top 10 most frequent results in a list.
I am looking to do this as a function rather than a pivot table as this is the way I have set the rest of the data to update.
I have searched around and seen some various examples, some that kinda work, some I can't get working and some I'm not even sure how to implement!
The closest I have got is with using the following code:
The data is found in column F and has a series of repeating data which I need to find the 10 most frequent. For client confidentiality I have had to remove this data and replace it with data from another column for the attached example.Please Login or Register to view this content.
With the code used above I am getting duplicates, such as:
Question Response
Question Response
Question Response
Client Requests
Question Response
Equipment Sent
Question Response
Configuration
Equipment Sent
Customer Error
I also need the code to skip any missing information, as this is possible to occur and the removal of just one cell will result in the code erroring.
I have attached a broken down example of how far I have got.
I am not looking for someone to do the work for me, but am simply lost and stuck and need pointing in the direction and I have always found responses on this site very useful.
Thank you in advance for any help given.
Regards, James
Example File:
Monthly Stats Example.xlsx
Bookmarks