Hi all,
I am working on one of the file wherein I need to find some names in a particular column from list of names and need to place the results in new column. Would be helpful if anyone can help me out. Attaching sample date for your reference.
Solved! Go to Solution.
Hi @Aggsneh
Based on what you sent, all the names were found in the dataset. See below using a find and replace logic to flag the fields with the name being matched.
Is this what you were looking for?
Pedro.
If I understand your requirements, you're trying to identify the description rows that contain one of the keyword names? If so, you can use a find and replace to search the description field for the keyword. I've appended it to a new column. Anything that matched would have a name field filled in.
I used a filter to separate out those that didn't match. Hope this helps!