I have a large excel with thousands of rows.
I have a string that i want to compare to with each row in column J in that excel and see how many matches are returned. if there is a match i want to record the data from column K & L from that row.
If the string i have is contained in the value in row J, that will suffice.
Thanks for the help