Search the Community
Showing results for tags 'excel column keyword row'.
Found 1 result
-
Hi, Anyone have assist for me on the following? What I need to achieve is to read a specific column (example, column L) for a specific keyword (example, "SIGN") and then get the corresponding row data (example, Keyword "SIGN" can be found in column L row 2, row 6 and row 10. Then I need to grab the data from the whole row 2, row 6 and row 10.) I have read the example _ExcelReadArray but it I can't seems to target only specific keyword. Also, I only require the information from the correct row not all the rows. Any advise or example you guys can point me to is much appreciated. Thanks.