List the Common Values in A Column

[austinandreikurt]

Hi, I have a list of values, might be numbers or text or group of words, but they will be just considered as value in a cell individually from A2:A300. I want to list the top 5 of the most commonly used values from the list and put them in Cell B1 only. Please make the formula easy to edit if incase I will need the top 4 only. But max will be top 5. Thank you!

 

[sandy666]

Mine is Excel 2016 but office excel is 2013 only. Okay, still thanks for attending the question. I can create the VBA codes myself unfortunately, vba is not an option to us. I'll be waiting then for a working formula just in case. Thank you.

You are welcome