Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation of ALPHA and NUMERIC cells? | Excel Discussion (Misc queries) | |||
Concatenation and skipping blank cells | Excel Worksheet Functions | |||
Find the zero(s) and remove from a concatenation | Excel Programming | |||
how to vlookup returning a concatenation of 2 cells | Excel Programming | |||
concatenation of cells | Excel Programming |