Luci0
09-29-2015, 05:34 AM
Gurus,
I have a Named Range "Rng_Output" made of 300 lines and 15 columns, from which I want to select a specific Column, and then work on that column as per following cases:
1. Identify a cell from Column 1, having the word "*Jar*" in it, and extract its row number;
2. Identify a cell from Column 2, having the word "YES" in it, and extract its row number;
3. Identify a cell from Column 4, having the biggest value of its own column, and extract this number;
4. Identify a cell from Column 5, having the biggest value of its own column (but without considering the values on the first 10 lines of that specific column), and extract this number.
Thanks,
Luci0
I have a Named Range "Rng_Output" made of 300 lines and 15 columns, from which I want to select a specific Column, and then work on that column as per following cases:
1. Identify a cell from Column 1, having the word "*Jar*" in it, and extract its row number;
2. Identify a cell from Column 2, having the word "YES" in it, and extract its row number;
3. Identify a cell from Column 4, having the biggest value of its own column, and extract this number;
4. Identify a cell from Column 5, having the biggest value of its own column (but without considering the values on the first 10 lines of that specific column), and extract this number.
Thanks,
Luci0