Grouping data

[SylviaK]

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

[SylviaK]

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