Hi,
I'm sure it's easy but, I have two columns of data a1:a300 and b1:b300 and each contain part codes like 01ABC02.
Some codes are repeated in each column and
I want to find (and display the codes) the codes in column a that match the codes in column b. I've tried Or(Exact) but I think that only works with text only.
Any help is much appreciated.
Thanks
I'm sure it's easy but, I have two columns of data a1:a300 and b1:b300 and each contain part codes like 01ABC02.
Some codes are repeated in each column and
I want to find (and display the codes) the codes in column a that match the codes in column b. I've tried Or(Exact) but I think that only works with text only.
Any help is much appreciated.
Thanks