Hi,
I just joined in hopes of getting some help and hoping to help others as well. I tried searching the forums so if this has already been solved, I do apologize.
I currently have a spreadsheet with two columns and I'm trying to highlight items in column A that are in column B. The only problem is that in a number of cases, the values aren't going to match exactly due to different references by different departments in the company. So, Server1 is the same as Server1z. I started to manually search & highlight, but figured that there has to be a better way. Because Column A has just under 200 rows, and Column B has just over 4000 rows, it'd take too long to do manually.
Here's an example of the spreadsheet:
Column A Column B
Backup Client Name DB Server Name
Server1z Server1
Server2z Server3
Server3z Server16
Server10z Server18
Server16z Server20
Server20z
Server25z
Based on this example, I'd like for Server1z, Server3z, Server16z & Server20z to be highlighted in Column A because everything but the z matches from column B. All the solutions I've found here an elsewhere online seem to have to have exact matches for values.
I appreciate any help you can provide.
-Mike
Bookmarks