find by concatenation of cells
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 -- Valeria |
All times are GMT +1. The time now is 02:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com