Formula to return A ∩ C but exclude similar values of B

[N0043]

I have three ranges of numbers,

A[91-129] , B[104-128], C[72-149]

and want to return like values of A and C but exclude all similar B values, so that the output is [91-103, 129].

What's the formula I need for this?

Thanks for reading

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.