How to match the values?

[Eric]

Does anyone have any suggestions on how to match the values?
I would like to find the match values, if the any period from col A to Col B
on any single row within the range on below rows, then return 1 under column
C, else return 0 under column C.
For example,
[A] [C]
10:30 10:45 0
11:45 12:00 1
11:30 12:00 0
12:00 15:00 0
15:00 15:15 0

Does anyone have any suggestions on how to do it within Excel?
Thanks in advance for any suggestions
Eric

 

[Jacob Skaria]

In C1
=IF(COUNTIF(A:A,B1),1,"")

If this post helps click Yes

 

[T. Valko]

Try this:

=--(SUMPRODUCT(--(A$2:A$6<=A2),--(B$2:B$6>=B2))>1)

 

[Jacob Skaria]

Oops; I dont think I have understood your query correctly

In C1
=IF(COUNTIF(A:A,B1),1,"")

If this post helps click Yes
---------------
Jacob Skaria

Does anyone have any suggestions on how to match the values?
I would like to find the match values, if the any period from col A to Col B
on any single row within the range on below rows, then return 1 under column
C, else return 0 under column C.
For example,
[A] [C]
10:30 10:45 0
11:45 12:00 1
11:30 12:00 0
12:00 15:00 0
15:00 15:15 0

Does anyone have any suggestions on how to do it within Excel?
Thanks in advance for any suggestions
Eric

 

[pogiman via OfficeKB.com]

Assuming [A], and [C] is in the first row enter this formula in C2:

=IF(countif($A3:$A$<last row/record#>,$B2)>0,1,0) ->then copy the formula
downward.

The formula does not include the current row in column A to match column B.
If you would like to include the current row, change $A3 to $A2.

Does anyone have any suggestions on how to match the values?
I would like to find the match values, if the any period from col A to Col B
on any single row within the range on below rows, then return 1 under column
C, else return 0 under column C.
For example,
[A] [C]
10:30 10:45 0
11:45 12:00 1
11:30 12:00 0
12:00 15:00 0
15:00 15:15 0

Does anyone have any suggestions on how to do it within Excel?
Thanks in advance for any suggestions
Eric

 

[pogiman via OfficeKB.com]

Assuming [A], and [C] is in the first row enter this formula in C2:

=IF(countif($A3:$A$<last row/record#>,$B2)>0,1,0) ->then copy the formula
downward.

The formula does not include the current row in column A to match column B.
If you would like to include the current row, change $A3 to $A2.

Does anyone have any suggestions on how to match the values?
I would like to find the match values, if the any period from col A to Col B
on any single row within the range on below rows, then return 1 under column
C, else return 0 under column C.
For example,
[A] [C]
10:30 10:45 0
11:45 12:00 1
11:30 12:00 0
12:00 15:00 0
15:00 15:15 0

Does anyone have any suggestions on how to do it within Excel?
Thanks in advance for any suggestions
Eric