Need Help Excluding Values From on Array

[TGA123]

Please see the attached excel file for clarification. I want to reference an existing array, and output the same array but excluding 2 particular values. Also, I only want one occurrence of these numbers to be removed from array. For example, in the example I have 116 listed as a value I want removed from the array, and 116 occurs twice. I only want one 116 to be removed not both.

 

[p45cal]

See attached cell H5 formula:

=RemoveSome(F5:F13,D5:D6)

RemoveSome is a named Lambda formula, which may be more complex than it needs to be, it's just the first thing that worked.
It removes the uppermost instance of the values, not that this makes any difference if the values in the Existing Data Set are sorted.
If a value is repeated in the values to be removed, still only one value is removed.

 

[Peter Bartholomew]

I decided I just had to use REDUCE as part of the solution to remove values!

= LET(
    reduced, REDUCE(existing, remove, zeroMatchλ),
    SORTBY(reduced,NOT(reduced))
  )

where

zeroMatchλ

= LAMBDA(data,value,
     LET(
        k, SEQUENCE(ROWS(data)),
        r, XLOOKUP(value, data, k, 0),
        IF(k <> r,data,0)
     )
  )

Mind you, I think removing the zeros in there entirety is more in keeping with dynamic array formulas

= LET(
   reduced, REDUCE(existing, remove, zeroMatchλ),
   FILTER(reduced,reduced))