Creating a dynamic list of strings and ranking how often they appear?

I'm pulling some information from a database, where we have a bunch of different strings (modules for a piece of software). I'd like to be able to create a ranked list of how often they appear.

For example:

BugID       Module
-------     -------------------
515         Core
516         Audio
517         Bios
518         Core
519         Audio
520         Hardware

I'd like to be able to generate a list that looks like this:

Module                     Count
-------------------       -------
Audio                        2
Core                         2
Bios                         1
Hardware                     1

I was trying to avoid doing it in a VB macro if possible. There's a lot of different module names so need some way to capture the strings from the "module" cells and then count how many times they appear and rank them.

Thanks for any help!

HI,

As the formula in Column E is array function in case of any change , use Ctrl+Shift+Enter combination key to activate array.
'
Formula in E3

Formula:

=IFERROR(INDEX($B$3:$B$500,MATCH(0,COUNTIF($E$2:E2,$B$3:$B$500),0)),"")

Formula in F3
=IF(E3="","",COUNTIF($B$3:$B$500,E3))
Punnam

That was fast, thanks so much!!

Hi Justmill,

Thanks for the feedback. if the Question answered mark the thread solved using the thread Tools

Punnam

Done, thanks again!