Oct 19 2021 02:15 AM - edited Oct 20 2021 03:40 AM
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 result(values that are not matching between columns A and B): 20201120|20191003
Thank you,
Mahender
Oct 19 2021 03:59 AM
The attached workbook (now a .xlsm) uses a custom function to return the mismatches.
You'll have to allow macros when opening the workbook.
Oct 19 2021 04:14 AM
@Hans Vogelaar Thanks a lot for your help, its working. Have a good day.
Oct 20 2021 03:43 AM
Oct 20 2021 04:18 AM
The attached version returns missing dates from both strings. It doesn't find dates that are within 5 days of each other; that is a step too far.