<div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;color:#333333;"><span style="color:#1d2129;font-family:'system-ui', '-apple-system', BlinkMacSystemFont, sans-serif;font-size:14px;">=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))))</span></div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;color:#333333;"><br></div><span style="color:#333333;font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;">정신차리고 보니 엑셀에서 이런 수식을 작성하고 있는 저를 발견했습니다. </span> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;color:#333333;">그만 자야겠습니다....</div> <div style="font-family:gulim, Dotum, Helvetica, AppleGothic, sans-serif;color:#333333;"><br></div>
출처 |
(컴게 보다는 여기가 더 어울리는거 같아서 옮겨옵니다.) |
<img src="http://colorworld.kr/kesso/coolpix775.jpg" alt="coolpix775.jpg">
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.