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 |
Apologies the second line should read
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 | Contains Tax 3 or 6.2 or 6.4 |
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 |