Hello,
I have the following problem:
in column A I have series of numbers separated by commas (1,4,7, etc.). The numbers range from 1 to 27. I need to find in a separate column if, for instance, the cell A2 contains the number "1". I tried various formulas like find, search, etc. the problem is that the results is "true" even if, for instance the string in the cell is "2,7,14". I mean I need to find only occurrences of the exact number in the string. Hope it is clear.
Thank you.
I have the following problem:
in column A I have series of numbers separated by commas (1,4,7, etc.). The numbers range from 1 to 27. I need to find in a separate column if, for instance, the cell A2 contains the number "1". I tried various formulas like find, search, etc. the problem is that the results is "true" even if, for instance the string in the cell is "2,7,14". I mean I need to find only occurrences of the exact number in the string. Hope it is clear.
Thank you.