함수 관련 도와주세요

@Y2J 님 버전문제로 TOCOL이나 TOROW 함수를 사용할 수 없어서 H2셀에 임시 수식을 하나 넣었습니다.
=LET( X, 일간승무표!A1:AR232, S, SEQUENCE(ROWS(X) * COLUMNS(X)), Y, INDEX(X, ROUNDUP(S/COLUMNS(X),0), MOD(S,COLUMNS(X))), MATCH(I2, Y, 0) )

A5 =LET( A,일간승무표!A1:AR232, B, OFFSET(일간승무표!A1,ROUNDUP(H2/COLUMNS(A),0)+3,MOD(H2,COLUMNS(A))-1, 19,1), D, OFFSET(B,0,5), E, OFFSET(B,0,2), SORTBY( FILTER(D, E>0), FILTER(E,E>0)) )

B5 =LET( A,일간승무표!A1:AR232, B, OFFSET(일간승무표!A1,ROUNDUP(H2/COLUMNS(A),0)+3,MOD(H2,COLUMNS(A))-1, 19,1), C,  OFFSET(B,0,1), E, OFFSET(B,0,2), F, IF(C>0,C,B), SORTBY( FILTER(F,E>0), FILTER(E,E>0)) )

C5 =LET( A,일간승무표!A1:AR232, B,OFFSET(일간승무표!A1,ROUNDUP(H2/COLUMNS(A),0)+3,MOD(H2,COLUMNS(A))-1,19,1), E,OFFSET(B,0,2),
SORT(FILTER(E,E>0)) )

J5 =LET( A,일간승무표!A1:AR232, B, OFFSET(일간승무표!A1,ROUNDUP(H2/COLUMNS(A),0)+3,MOD(H2,COLUMNS(A))-1, 19,1), C, OFFSET(B,0,6), D, OFFSET(B,0,7), E, OFFSET(B,0,2), F, IF(D>0,D,C), SORTBY( FILTER(F,E>0), FILTER(E,E>0)) )

첨부파일 : 2024-10월간계획표-1.xlsx