Finding the duplicate occurances and displaying their frequency in descending order

Hi,

i have a set of data in excel as followes:

A b
16 12
14 1
5 3
16 43
1 14
3 5
5 3
the desired solution that i am looking to get in c and d and e is as followes:
C d e
3 5 3
14 1 2


in the above example at the top there is 3 in c1 and 5 in d1 because it has occured 3 times in the data also their frequency if displayed in e1 as 3 because it has occured three times and c2 is 14 and d2 is 1 because it has occured 2 times also their frequency is displayed in e2 as 2 as it has occured 2 times in the data.

I have also attached a workbook to receive some solutions , so hoping to receive genuine response from serious contributors.

Thanks

Why have you posted this twice? You should not create duplicate threads (see Forum Rule #05 at the top of the screen).

Pete

HI, Pete i havent posted this twice as you know the question and the desired solution both are different from previous posts

What is this one, then:

https://www.excelforum.com/excel-for...ml#post5460316

if not a duplicate of this thread in a different sub-forum?

Pete

solution is different and question is different as well