Comparing 2 Columns?

  • It looks like the numbers in column A are true numbers, while the numbers in column L are text entries.

    You will need to either convert column A to text (Data>Text to Columns > Next > Next > Select Text > Finish)

    or change formula to convert number to text...

    e.g =MATCH(A2&"",L:L,0)

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!