Hi Fellows,

I have a column which have thousands of entries. These all are either 7,8 or 9 digit number. Each number in that column ends up with either digit 1 or digit 2. I need to put a next column with the existing one and name the entries which are ending up with digit 1 with specific name & the other ones ending with digit 2 as well, just like an indicator in next column for filtering purpose.

Hope you get my point. Please let me know which formula i can populate to obtain the desire result.

Thanks!