Having 1 column add up word occurances from 2 other colums & sort?

[szm187]

So, I have two columns on a sheet that all contain drop down boxes for various information. We'll refer to them as column 1 and column 2.

In column 3, I want to have the highest instances of those words sorted with the highest on top, and downward from there, along with the number of times it appears in either column 1 or 2. (And I want the sorting to be dynamic, i.e. when I change what's in column 1 or 2, it will re-rank them according to highest number)

i.e.


Column1 Column2 Column3 (Column4-#)
Bob Tom Bob 5
Joe Bob Tom 2
Bob Joe 1
Tom Bob
Bob


Obviously, there would be more choices, but I'm being simple here. I have the drop downs and what not for the 1st 2 columns, I just need to know how to make 3 & 4 happen. Any help would be appreciated!

[tehneXus]

Hi,

please find a VBA solution attached: Count.xlsm