Occurence based on criteria (Formula)

HI experts,

I have a excel sheet with data layout as following in two columns

A1 D
A1 D
A1 D
A2 D
A2 D
A3 D
A3 D
A4 D

What i need is to write a formula which should take "D" as criteria and give the value in Column A which has the maximum occurences, then the item with 2nd maximum no. of occurences and so on.

The output should be
A1 D
A2 D
A3 D
A4 D

Currently I am stucked.
I would appreciate any I would get from your side.

Thanks