Jan 25 2021 12:45 AM
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 | ||
Rank | Name | Referrals |
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.
Jan 26 2021 07:27 AM
Sounds like a good use of a pivot table, where it could be ordered by frequency of name or sum of referrals.