Howdy,

I have an interesting challenge I thought there was a simple formula to solve, but I can't think of it! Do you mind taking a minute to help me out?

Bear with the following illustration:

Suppose you are a budding business tycoon and opened a convenience store each January over the past 5 years. These are Sites A-E. You look at a revenue spreadsheet (Table 1) with 5 years of calendar months (60 months) as rows and Site locations as columns (5 sites). Because they were opened on a staggered basis, Site A shows revenue for every month, Site B shows revenue for years 2-5, Site C years 3-5, etc.

Now you want to create Table 2, which compares each site based on their age instead of Calendar month. So instead of Jan-2012, you look have rows showing Month 1, Month 2, Month 3.

What formula would automatically retrieve the ranges from Table 1? Essentially, it would relist the same range from Table 1 but skip all the blank cells so you could compare each site's first month, second month, etc.