Duplicate in another column
Posted by Charles on October 30, 2001 8:19 AM
I wonder if you could help me.
I have a spreadsheet that contains two columns of vehicle registration numbers.
I want to be able to tell if a registration in the second column is *also* present in the first column.
I would like a macro that will run down the second column and if it finds a duplicate registration in the first column then put the word 'duplicate' in column 3.
(I wonder if this best solved by a formula rather than a Macro.)