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.
1
toROW(1:1)
that way as it copies down it will grab the second then the third. I would also put the IF() in the second driterion of the MATCH:=INDEX(List of keywords,MATCH(LARGE(IF(date column="This Week",number of clicks),ROW(1:1)),IF(date column="This Week",number of clicks),0),0)
This way you do not return matches that are not filtered.