Hi Kurt, Thanks so much for your help! However, I want to make sure 2 things... Table A has random dates ranging from 1/1/2009 to 12/31/2015 (not every date is represented, i.e. July 22, 2013 might not be in there). Thus, for my region tables, I set them up so that each region table has data for EACH date ranging from 1/1/2009 to 12/31/2015 (only the dates that "match" with Table A will be filled in the columns). Will your method still work (merging the 4 region tables into 1, we would have duplicate dates (i.e. 1/1/2009 for west, north, south, east)) ? Also, what is meant by "in=a" and "if a" ? I haven't used the "in=" function before so please clarify for me. Thanks again!
... View more