Ok guys last one.
Here is my array formula which gives me the TOP item found in a list. It only gives me 1, I want top 5 items.
Is there a formula that will give me the TOP 5 items?![]()
=INDEX(data!$B$5:$B$304,MATCH(MAX(COUNTIF(data!$B$5:$B$304,data!$B$5:$B$304)),COUNTIF(data!$B$5:$B$304,data!$B$5:$B$304),0))
Thank you,
Brian
Bookmarks