hi
Is there a smarter way for grouping the below data other than using multiple if functions:
Essentially, if the value contains 3.1,3.2,3.3,3.4,3.5,6.2, or 6.4 I want the comment to read "Contains Tax 3 or 6.2 or 6.4"
if the value only only contains either 5.1,5,2 or 5,3, I want the comment to read "Contains Tax 5 only" and
all other combination to be "other"
Many thanks,
Sylvia
| Value | Comment |
| 1.1,3.4,4.3,6.1,6.2,8.4 | Contains Tax 3 or 6.2 or 6.4 |
| 6.2,8.1 | Other |
| 8.4,5.3 | Other |
| 8.4,5.1,3.3 | Contains Tax 3 or 6.2 or 6.4 |
| 8.4 | Other |
| 1.1,12.2,3.1,7.1,7.3 | Contains Tax 3 or 6.2 or 6.4 |
| 4.1 | Other |
| 8.5,9.1 | Other |
| 8.5,9.1 | Other |
| 8.5,9.1 | Other |
| 5.1,5.2 | Contains Tax 5 only |
| 5.1,5.2,5.3 | Contains Tax 5 only |
| 5.1 | Contains Tax 5 only |
| 5.2 | Contains Tax 5 only |
| 3.1,3.2,3.3,3.4 | Contains Tax 3 or 6.2 or 6.4 |
| 6.3 | Other |
| 3.5 | Contains Tax 3 or 6.2 or 6.4 |
| 1.1,3.1,3.5,7.2,9.3 | Contains Tax 3 or 6.2 or 6.4 |
| 3.5 | Contains Tax 3 or 6.2 or 6.4 |
| 1.2,3.1 | Contains Tax 3 or 6.2 or 6.4 |
