Hi,
I am absolutely stumped and would really appreciate your help.
I am trying to highlight + compare and have aligned the duplicate matching "Keywords" Values in column A vs. Column C, while making sure their corresponding "Position" values stay partnered/aligned with their appropriate keyword. Also, making sure nothing weird happens to data that doesn't match (i.e. new keywords that aren't present in both keyword lists that should just stay unhighlighted)
Here's a reworded explanation incase what I said was unclear.
[[ See attached excel ]]
Compare Column A keywords position changes by having them align with Column C keyword position AND having them be highlighted some color (to easily visually see that these keywords are matching) + making sure their corresponding "positions" [ A & B ] vs. [ C & D] stay partnered / aligned with their keywords. Also the new keywords that aren't present in both columns to not be screwed up or removed.
Thanks!