Finding Missing Values In Selection

[felix18807]

Hi All,

I'm pasting ('|' separated) values into a variable which I then use to trigger a selection (see below). The question I have is -

Is there a way of generating a list of values in this variable list which are absent from the available values in the field list (i.e. missing in the selection)

(111111|222222|3333333|4444444|5555555|66666666|77777777|88888888|999999999|0000000000)

Many Thanks

[MayilVahanan]

Hi

PFA

Check the button?

use Select excluded

Are you looking this?

Edit:

Check the file now.

[#3 · Accepted solution]

See if the attached sheet is what you are looking for.

[felix18807]

Nice work rebeccad!

I have learned more than I asked by looking at this file. Many Thanks