I need some help writing a formula.
In one cell, let's call it A1, is a 5-digit number. In another cell, let's call it B1, is a list of 5-digit numbers separated by commas.
A1 - 12345
B1 - 12222,23456,34531,54356
My goal is to have a formula that will look at the first 2 digits of every 5-digit number separated by a comma in B1 and see if it matches the first 2 digits of A1. If there is a match, I'd like a "1", and a "0" if there is no match.
Can anyone help me write this?