Search in Excel file
The attached Process searches for a certain value in an Excel file and retrieves its row and column index.
In case that value exists multiple times, then all the row and column indexes will be retrieved.
1 person likes this idea
I love this Process, and would like to use it but I'm struggling to reverse engineer this so that:
- All rows of one specific column are checked against a second list of values. (instead of all columns being checked)
- If any of the second list of values match in the specific column, create new column (next to column that is being checked) and put a "Found" inline.
Simple process to search for a certain value in an Excel file and retrieve its row and column index.