Originally Posted by
kdestef1
I had someone help me with this formula already but I can't remember the exact formulation. I have a string of numbers (2 columns) that I am trying to compare to each other to find numbers that don't match to any number in the other column. I would like for the formula to give me a "1" if the numbers match and a "0" if the formula doesn't find a match, i.e.:
WORD ACCESS
247604 1 247604
290312 1 290312
296787 1 296787
297038 0 297052
312471 1 312471
320959 1 320959
I would like to compare the WORD list to the ACCESS and vice versa. I know it's a pretty simple formula but just not knowledgeable enough in Excel.
Bookmarks