Extract all number that is not between multiple two numbers.

[lorajean28]

First thread, i hope someone helps. Need to extract all number that is not between multiple two numbers.




I will be thankful for anyone who will helps. (heart)

[MarvinP]

Hi lorajean and welcome to the forum,

I have no idea how you arrived at 44 for your first answer given the 11 and 20. Can you explain how you got 44 then 82 etc..

[lorajean28]

Hi lorajean and welcome to the forum,

I have no idea how you arrived at 44 for your first answer given the 11 and 20. Can you explain how you got 44 then 82 etc..

44
82
150
515
are not between 11 to 20, 21 to 30, 51 to 60 and so on

[John Vergara]

Hi to all!

You can use this formula:

=FILTER(D2:D17,1-COUNTIFS(A2:A6,"<="&D2:D17,B2:B6,">="&D2:D17))  

Blessings!

[lorajean28]

Hi to all!

You can use this formula:

=FILTER(D2:D17,1-COUNTIFS(A2:A6,"<="&D2:D17,B2:B6,">="&D2:D17))  

Blessings!

Wow! Its working, thank you for your help! <3

[lorajean28]

It so nicee, people here are so amazing~ Thank you

[John Vergara]

I'm glad to help. Thank you for the added rep. Blessings!