Professor Excel

Comments 1

  1. Nikola Grujicic Excel

    The problem can also be solved by inserting helper column “A” with formula:

    =IF(ROW()*1/7=INT(ROW()*1/7),ROW()*1/7,INT(ROW()*1/7)+1)

    applied downward
    and formula:

    =INDIRECT(ADDRESS(ROW()-(A8-1)*7,COLUMN()+(A8-1),4))

    in cell “B8”, also applied downward.

Leave a comment

%d bloggers like this: