Forum Discussion
comparing pipe-delimited values in excel
Hello everyone, Whats the best way to compare two cells with pipe-delimited values in excel, here is an example: Col A: 20210923|20210603|20201120|20191003 Col B: 20210923|20210603 Expected resul...
The attached workbook (now a .xlsm) uses a custom function to return the mismatches.
You'll have to allow macros when opening the workbook.
HansVogelaar Thanks a lot for your help, its working. Have a good day.