Love4Excel
New Member
- Joined
- Apr 11, 2013
- Messages
- 3
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!
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!