How to Compare two columns based on Partial match

abi007

New Member
Joined
Oct 6, 2020
Messages
1
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
  2. MacOS
I need help on how to compare data in two col based on partial match so I want to compare then match with the right most characters so may be first 10 characters from the right or first 5 characters from the right then match with the same in col B and if they match identify them some how either color etc.

Keep in mind Col A and Col B are not in the same order or anything so for each cell in col A a search of the entire col B needs to be done for a match.

Any help?
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,113,890
Messages
5,544,887
Members
410,643
Latest member
sng
Top