I am looking for a Google Script to be built with the purpose of finding duplicate values (names) from two lists in two separate columns.
There will be Column A, and Column B. The script needs to be able to find duplicates values (names) between the two columns. They might not be on the same row - and may differ slightly in spelling.
I need a script / formatting to highlight and extract into a new column all duplicates found.
Let me know if you need any more details!