Adding multiple values in cell for table possible?

[Love4Excel]

Hello,

I am creating an excel sheet with a table. In some cases I would need to add multiple values inside a cell. But the filter should still count it as separate values. Example:

Filter tab is called Comment Type. Usually people give 1 sort of comment like: great, superb and awesome. But sometimes they may say something like:

Awesome comments. Superb comments. Great comments.

In this case I would like to add the values:

Awesome, Superb, Great in one cell because it applies to the same line.

Is this even possible? Or is there a possible creative solution you'd apply?

Hopefully someone can help me out here!

 

[Gary's Student]

If a single comment should be a "1" and tow comments should be a "2", then just count the number of commas and add one.

 

[s hal]

I'm not following this at all.. Are the only possible inputs great/superb/awesome and sometimes people include additional words? If all you care about is the 3 (or more) words, you could do a search for those words and turn a flag on/off if they are present in a large string of text that you combined (if that makes sense). If you are trying to comb ALL the words and make unique lists of every single word used, that's something else entirely, and while possible, would take a lot of effort and probably not produce anything you actually want to see...

 

[RhinoNeil]

Not certain exactly what you are trying to do. Are you trying to filter by a column when there could be multiple entries in the cell? So you could have "Awesome, great" and another could have "Awesome, superb"? But you want to filter all those with "Awesome" as a comment? Just use the Text filter CONTAINS "Awesome" instead of EQUALS "Awesome".
Or create pick lists with words and you can add multiple words as people haver already asked?