Test within a range?
 

I have a range of sequintial starting and ending numbers in two columns.
Then I have a huge list of numbers that I need to verify if they fall between
one of these ranges.

For example A1 contains 1000000000 and B1 contains 1010000000 and C1 is
1000340568. I need a forumla in D1 that would return "True" that the C1
number is between A1 and B1. I tried COUNTIF but that only works for a list
of numbers, not the start and end that I have in the above scenario.

Test within a range?
 

Try one of these:

Inclusive:

=AND(C1=A1,C1<=B1)

Between:

=AND(C1A1,C1<B1)

copy down as needed.

Biff

"JC" wrote in message
...
I have a range of sequintial starting and ending numbers in two columns.
Then I have a huge list of numbers that I need to verify if they fall
between
one of these ranges.

For example A1 contains 1000000000 and B1 contains 1010000000 and C1 is
1000340568. I need a forumla in D1 that would return "True" that the C1
number is between A1 and B1. I tried COUNTIF but that only works for a
list
of numbers, not the start and end that I have in the above scenario.

Test within a range?
 

Thanks

"T. Valko" wrote:

Try one of these:

Inclusive:

=AND(C1=A1,C1<=B1)

Between:

=AND(C1A1,C1<B1)

copy down as needed.

Biff

"JC" wrote in message
...
I have a range of sequintial starting and ending numbers in two columns.
Then I have a huge list of numbers that I need to verify if they fall
between
one of these ranges.

For example A1 contains 1000000000 and B1 contains 1010000000 and C1 is
1000340568. I need a forumla in D1 that would return "True" that the C1
number is between A1 and B1. I tried COUNTIF but that only works for a
list
of numbers, not the start and end that I have in the above scenario.

Test within a range?
 

You're welcome!

Biff

"JC" wrote in message
...

Thanks

"T. Valko" wrote:

Try one of these:

Inclusive:

=AND(C1=A1,C1<=B1)

Between:

=AND(C1A1,C1<B1)

copy down as needed.

Biff

"JC" wrote in message
...
I have a range of sequintial starting and ending numbers in two columns.
Then I have a huge list of numbers that I need to verify if they fall
between
one of these ranges.

For example A1 contains 1000000000 and B1 contains 1010000000 and C1 is
1000340568. I need a forumla in D1 that would return "True" that the
C1
number is between A1 and B1. I tried COUNTIF but that only works for a
list
of numbers, not the start and end that I have in the above scenario.