I am trying to compare two columns to see if they carry the same values - column A has 556 values (starling at line 3), and column B has 69 values (starting at line 3)- I want to see if the values in column B match the values in Column A;
I used the following formula but it does not seem to work:
In case you are wondering why your formula is not working
"2" refers to the second column in range $B$3:$B$69. As you can see, there is no second column in the range. There is only one column and that is column B
Thanks to rizvisa1
for this tip on the forum.