Prev: Average various variable ranges
Next: how to change a figure into word formate in below the column of e.
From: Valeria on 21 Apr 2010 04:30 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 |