Google Sheets Select Number From List Excluding Another List

Thanks hrlngrv,

Thats a really good solution too, not that I understand too much of it, and the range part works a treat.

In answer to your questions, I think the one about Sort is directed towards Mr Fluff, so I will let him answer that. But I can answer yes to the second question, the end goal is random sampling without replacement. And I appreciate the extra formula that randomly shuffles the whole selection of numbers in A3:A143, very useful to know.

Thanks for your help, both of you, invaluable.

PS Sorry to post this bit again, maybe I should start a new thread, but is there a way to add the number selected by the formula to the end of the list in banned numbers.? A function or macro to run with a key press.? So that when I run a set hot key it gets added to the Banned Numbers column, but not when it is recalculated each time you press delete or change another value.?

Thanks again