Forum Discussion
Help for formula for extracting different words and sorting them among spreadsheet
Hello all, I need a specific formula. I've search a lot on internet, found way more complicated requests but not this one. I will be typing different words in different cells and columns. Some...
It depends on which Excel version/platform you are. And in any case it's better to define the range in which to search, otherwise you could wait recalculation forever.
I am using
Microsoft® Excel® for Microsoft 365 MSO (Version 2112 Build 1) 64-bit
It is not a problem to define 15-20 words that I will use. After filling all the data I will know that I've used this, this and this word and I will be able to pre-define them in the final formula.
Attached is a photo of what I want to achieve
- If you are going to predefine the names that would be used, then here is what I would do for each defined name:
COUNTIF($B$2:$F$12,B28)
If you didn't define names, then I would use a dynamic list to display the unique names and then apply the above formulas to show the count of reoccurrence:
UNIQUE($B$2:$F$12) # to generate a unique list
COUNTIF($B$2:$F$12,B28) # to display the count- I think I've made it work 🙂 Thanks
