I have a table in Excel 2016, which includes the keywords of my paid search campaign.
I have already ranked the keywords based on their conversion rate (from highest to lowest), and now i need to allocate a total budget of 20K to each one of them, according to their rank.
Is there a formula to do that ?
The rank starts from 1 (highest rank) until 35 (lowest rank).
Bookmarks