Hi
See attached
Trying to create a formula that will display in D2 the most common word in a list. I've actually done that with =INDEX(range,MODE(MATCH(range,range,0))). I've also found the formula that will count how many times this word in any order comes up with =COUNTIF(range,"*word*").
Great
Now i want to find the 2nd most frequent, 3rd most frequent... 7th 8th etc.
And then do a count if for each
And then count the "cost" of each one so i can sort via cost to then make a graph.
in column D, E & F i have basically put what I am trying to achieve manually as i might not be making sense.
Many many thanks! Really will help with a project
Bookmarks