Wow, that was fast and looks to be exactly what I needed.
Is there a way I can drag that formula and make it work relatively? As in if I type it as you shown and drag it once to the right it would fill C2 or is that asking too much.
It would take a while to update all the cells in each cell (over 400) but I guess I would only have to do it once and it would be done.
Thanks a lot
Bookmarks