Hi all..

I kindly need some help with VBA.

i have a column of data (30 alphanumerical codes)

then i have a matrix (100 x 2) where in column 1 i have alphanumerical codes and in column 2 i have a list of 100 surnames.

For each of the 30 codes of the fist column, i need to check if they repeat on column 1 of the matrix (100 x 2). If so, i need to write that alpha code and the corresponded surname in a new matrix.

Thank you

]]>I kindly need some help with VBA.

i have a column of data (30 alphanumerical codes)

then i have a matrix (100 x 2) where in column 1 i have alphanumerical codes and in column 2 i have a list of 100 surnames.

For each of the 30 codes of the fist column, i need to check if they repeat on column 1 of the matrix (100 x 2). If so, i need to write that alpha code and the corresponded surname in a new matrix.

Thank you