I have two long columns I am trying to run a match on. 'A' column 800 rows the other 'b' 400
=match(A1,B:B) is the code and then I copy it down... the code populates correctly with the a1 changing in sequence as it should.
the first 100 or so rows perform correctly and then all of a sudden there are a ton of hits the rest of the way through a but most of them
are matching the same cell in column b that actually doesn't match.
has anyone seen this before?
I run a match on the