Problem description & analysis:
In the following Excel table, cell A1 and cell B1 contain strings made up of vertical line-separated numbers and walled in by vertical lines at both ends:
Task: find numbers that exist in A1 but does not exist in B1 and display them in the same format:
Solution:
Use SPL XLL to do this:
As shown in the picture below:
The symbol computes difference, which are members that are contained in set A but are not contained in set B. Symbol / concatenates two strings. $[] represents a string.