V
Valeria
Dear experts,
I would like to compare 2 large range of data and the criteria is a
concatenation of 4 cells.
Basically I need to know where (row) in range 2 I find the same
concatenation as in range 1 to perform an operation.
Ranges:
for range 1: Cells (row i, from column 2 to 7)
for range 2: Cells (row k, from Column 1 to 6)
I would like to avoid the loops for speed's sake....
Many thanks in advance for your help.
Kind regards
I would like to compare 2 large range of data and the criteria is a
concatenation of 4 cells.
Basically I need to know where (row) in range 2 I find the same
concatenation as in range 1 to perform an operation.
Ranges:
for range 1: Cells (row i, from column 2 to 7)
for range 2: Cells (row k, from Column 1 to 6)
I would like to avoid the loops for speed's sake....
Many thanks in advance for your help.
Kind regards