Copy matching values in range in two columns into another column

Hi F1ash,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

Thanks Robert - that's a great help and really efficient way of doing it.

If there was some data at the top of the columns and some more data below both columns, would it be possible to fix the range of the array? Of course this list may change but as long as I can fix the array range then it should not be an issue. I only want the data from the fixed array and not all of the data above and below.

Sorry I should have been clearer in my original post.

I've attached the file again so you know what I mean.

Thanks again

Try this where there needs to something on both sides of the name (one way I thought of from looking at the data):

Please Login or Register  to view this content.

The revised code will also automatically put in the duplicate number into Col. I.

Regards,

Robert