As far as the generic structure of your Array Formula is concerned ...
You can adapt following formula to your specific situation
Hope this will help
Thanks Carim! I'm not sure why my formula wasn't working even though I was pressing CTRL + SHIFT + ENTER after constructing the formula. Nevertheless, I tried your formula and for some reason excel liked your way better. Now I actually get what I'm trying to find. Thanks for the help!