I've been searching around for a way to do this but have had no luck so far.
Say I have a bunch of ranges of times. The start time is in Column A, and the end time is in Column B. These ranges overlap, often, so I might have:
A B
0 6
4 6
7 11
16 18
I have another column, column C, and I want to see how many of the ranges above the numbers in column C fit into.
So, if I have:
C
1
5
8
10
15
Then I want my outcome to be
D
1
2
1
1
0
Thank you for any help!
Say I have a bunch of ranges of times. The start time is in Column A, and the end time is in Column B. These ranges overlap, often, so I might have:
A B
0 6
4 6
7 11
16 18
I have another column, column C, and I want to see how many of the ranges above the numbers in column C fit into.
So, if I have:
C
1
5
8
10
15
Then I want my outcome to be
D
1
2
1
1
0
Thank you for any help!