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...
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
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
NowshadAhmedThanks. I've tried it but it gave an error. I am attaching a preview. I wanted to attach the demo file, but there isn't option to do so here.
- The B28 in my formula (COUNTIF($B$2:$F$12,B28)) is the reference cell for the defined names.
In your case it would be B17 instead of B28
COUNTIF($B$2:$F$12,B17) # Use this formula