Replacing $A:$A in the INDEX function with the column your word or phrases
are in and the range $A2:$A397 in the COUNTA function with the actual range
your words/phrases occupy.
Copy the formula down so it's in 6 rows. In the event the same item gets
selected twice, press F9 to recalc.
Hope this helps.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.