=IF(INDEX(INDIRECT(CONCATENATE(SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(ADDRESS($A$9,COLUMN(INDIRECT(CONCATENATE($A$7,"1")))+MATCH(B16,INDIRECT(A13),FALSE),4))),4),"1",""),$A$9+2,":",SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(ADDRESS($A$9,COLUMN(INDIRECT(CONCATENATE($A$7,"1")))+MATCH(B16,INDIRECT(A13),FALSE),4))),4),"1",""),$A$10)),MATCH($A$4,INDIRECT(CONCATENATE(SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(ADDRESS($A$9,COLUMN(INDIRECT(CONCATENATE($A$7,"1")))+MATCH(B16,INDIRECT(A13),FALSE),4))),4),"1",""),$A$9+2,":",SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(ADDRESS($A$9,COLUMN(INDIRECT(CONCATENATE($A$7,"1")))+MATCH(B16,INDIRECT(A13),FALSE),4))),4),"1",""),$A$10))))<$A$4,MATCH($A$4,INDIRECT(CONCATENATE(SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(ADDRESS($A$9,COLUMN(INDIRECT(CONCATENATE($A$7,"1")))+MATCH(B16,INDIRECT(A13),FALSE),4))),4),"1",""),$A$9+2,":",SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(ADDRESS($A$9,COLUMN(INDIRECT(CONCATENATE($A$7,"1")))+MATCH(B16,INDIRECT(A13),FALSE),4))),4),"1",""),$A$10)))+1,MATCH($A$4,INDIRECT(CONCATENATE(SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(ADDRESS($A$9,COLUMN(INDIRECT(CONCATENATE($A$7,"1")))+MATCH(B16,INDIRECT(A13),FALSE),4))),4),"1",""),$A$9+2,":",SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(ADDRESS($A$9,COLUMN(INDIRECT(CONCATENATE($A$7,"1")))+MATCH(B16,INDIRECT(A13),FALSE),4))),4),"1",""),$A$10))))
정신차리고 보니 엑셀에서 이런 수식을 작성하고 있는 저를 발견했습니다. 그만 자야겠습니다....
글쓰기