How to match the values?

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
Oops; I dont think I have understood your query correctly


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

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


Eric said:
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
Click to expand...
Click to expand...
 
Back
Top