I have a sheet with utilizes grouping, the rows in each group varies and the code I have is not dealing well with that
What I have is this
=COUNTIF(INDIRECT(ADDRESS(ROW()+1,3)&":"&ADDRESS(MIN(IF(ISBLANK(C2:C200),ROW(C2:C200))),3)),"Y")
What I want to do is to have the C2:C200 be the actual address, this is setting the end to 200 and as I create more groups with rows
the number will reach well over 200, so then I have to go in an edit the code to reflect the additional rows and thats a pain.
So if there are 10 rows in that group then I would like it to be C2:C12
the next group will need to start at C13 and it may have 90 rows so the Address would be C13:C103
Is there anyway to create an index column to search for the next group?
Excelissue.jpg
Bookmarks