This will get you part of the results, using Pivot Table.
The Rank numbers are not used.
Here is the data I used:

Comnt Freq
Info 2
GoodS 3
OJT 2
GoodE 1
Motiv 1
GoodS 3
GoodS 3
OJT 2
Info 2

Data Pivot Table Multiple Consoldation Ranges
Range: Select the 10 x 2 array shown above.
Layout: DATA = Count of Value
Double click on Row button
Advanced: AutoSort Descending
using field Count of Value
AutoShow ON Top 3
Options: Uncheck Grand Totals, AutoFormat
The result will look like this:

Row Freq
GoodS 3
OJT 2
Info 2

Rank of the items is implied by their position.