#33 — Find The Differences Between Contents of Two Cells

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:

=spl("=$[|] / (?1.split($[|]) \ ?2.split($[|])).concat($[|])/ $[|]",A1,B1)

As shown in the picture below:

Explanation:

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.

Comments

[Judith-Excel-Sharing]

For more related information:
🔹SPL download address: scudata.com/download-Desktop
🔸Plugin Installation Method: c.scudata.com/article/1652061135502
🔹References to other rich Excel operation cases: c.raqsoft.com/article/1651916536524
🔸SPL Programming (YouTube FREE courses): youtube.com/playlist?list=PLQeR-Ih...

[Judith-Excel-Sharing]

Feel free to reach out if you got any Excel tasks, and your problem might be featured in our next Excel hack series!
🚀Discord: discord.gg/hgbKEvJ4
🚀Reddit: reddit.com/r/esProc_Desktop/