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] [b] [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