Thansk heaps for your help (yet again!). However, I was using a simple example, the table of exclusions are much longer than in the question and so won't be able to use a formula. In excel I use an Index Match (not exact) and that works but need to replicate the logic in PQ.
Thanks but there are at least 20 ranges of numbers that need to be excluded plus I need the formula to be dynamic as the excluded numbers can change so a formula isn't an option. Anything else you can think of?
@tringuyenminh92 this solution works perfectly for my requirement, the only problem is that for the table "Reference" I have like 5k rows and for "Flight List" I have like 1.5m rows and when I try to add this to my report, clicking on the button close and apply, it keeps "Applying query changes" and never finishes, is there a way to optimize code execution? I think the problem is trying to apply the function for such a big number of rows.