How can I rank my top referral channels based on their frequency in a dynamic order?

Copper Contributor

I have a column with 600+ referral channels.

I want to rank the top 10 in a dynamic order, such that excel returns to me the name of the channel, the number of referrals made (from a CountIf function), and the rank correspondingly (similar to the table below)

 

Referrals
RankNameReferrals
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  

 

 

Here's a sample of the data

 

Referral Channels

Khalid AK
Khalid AK
Reem S
Zeina Z
Aya D
Hazem N
Zeina Z
Sumer K
Khalid AK
Guru
Zeina Z
Rami Z
Rami Z
Jad K
Yara D
Karim K
Ahmad S
Sumer K
N.D.
Khalid AK
Ahmad S
Ahmad S

 

Thank you.

1 Reply

@Khalidwak 

 

Sounds like a good use of a pivot table, where it could be ordered by frequency of name or sum of referrals.