Most valuable professional
  • Hot Topics

Excel Find the top five names and occurrence

Hi Friends, I have declared a range (A2:A25) in vba. Range contains names. PFB the table. Names David David Adam Mike Adam Adam Adam David Harry Robert Robert John John John John Adam Mike Mike John John Robert Robert Tom Tom Now i would like to display a message box with name top five occurrence with their occurrence.

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of January 3, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel