So, C1 will read =If( A1 = B1, 1, 0). The formula would be copied down column C. I am running into the issue that when comparing the A column with the B and there is an #/DIV0! error in either/both columns, then the result will be an error. What is the simplest way of resolving this issue. Would it by converting the formula the cells values to text? Looking for a formula to apply.
Further info: The list continuous down each column with perhaps non error results, say, regular numbers.