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!