I want a formula that returns the top 10 keywords (by clicks) for the last week from a data set.
This works, but returns duplicate values;
INDEX(List of keywords,MATCH(LARGE(IF(date column="This Week",number of clicks),1),number of clicks,0),0)
I've done something similar before where the formula in the next row will check the first and return the next different value, and so on, but I can't get it to work for this.
Any ideas? No VBA please.