RaqForum 41 No.
90 View  • 
     ...

Find the difference between contents of two cells

 

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:

A

B

1

|55|56|60|99|120|

|55|56|62|100|121|130|210|312|

Task: find numbers that exist in A1 but does not exist in B1 and display them in the same format:

D

1

|60|99|120|

Use SPL XLL to do this:

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

Picture1png

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.

Source:https://stackoverflow.com/questions/78192482/how-do-i-go-about-removing-values-found-in-one-cell-out-of-another-cell


 
 •  90 View  •