Records from Table-A, omitting entries from Table-B?

[jeffminder]

Need help with formula which shows records from RC[R], omitting records in RIH[R].   Have tried suggestions found online, including AI chat... no luck yet.   This formula will be used in the Auto-compute: 'suggested values' section.

Started with this, but going in wrong direction:
FILTER(RC[R],RC[R] NOT IN RIH[R])

TIA!

[jeffminder · Accepted solution]

Greatly over complicated...  🙂
This does it: RC[R] - RIH[R]