I am trying to determine if certain we a purchase a particular stock occurred between multiple time periods- see pic, but in short I want to search Column L for B2, and check if the date in A2 falls between any of the date ranges for the occurrences of B2. Sorry for the illustration I couldn't get it to paste correctly.
I hope I explained that right- thanks for any help.
<tbody>
</tbody>
I hope I explained that right- thanks for any help.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATE
<colgroup><col></colgroup><tbody> </tbody> | SYM
<colgroup><col></colgroup><tbody> </tbody> | SYM
<colgroup><col></colgroup><tbody> </tbody> | BEGIN
<colgroup><col></colgroup><tbody> </tbody> | END
<colgroup><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>