PDA

View Full Version : Sleeper: Extract cell info from specific column selected out of Named Range



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

p45cal
09-29-2015, 02:56 PM
cross posted and resolved at:
http://www.vbaexpress.com/forum/showthread.php?53855-Extract-cell-info-from-specific-column-selected-out-of-Named-Range
http://www.mrexcel.com/forum/excel-questions/890339-extract-cell-info-specific-column-selected-out-named-range.html

Luci0, take a read of http://www.excelguru.ca/content.php?184