I am working on two formulas. One to recognize the first cell in a row with data in it and then count that cell and the next five. Also another one to recognize the last column with data and to count the previous 6 rows starting with that column. I might be able to come up with some terribly long and dreadful formula that takes two days to read and if one mistake is in it it takes another 4 days to figure it out. I think my other posts express the idea in totality. also there should be dummy excel file attached.