오빠두엑셀 `2026 무료 챌린지` 오픈! 완주하고 수료증 받아가세요!
5년 연속 IT분야 베스트셀러! 「 진짜쓰는 실무엑셀 」로 2026년 공부 끝내기
엑셀이 막히셨나요? Q&A 게시판에서 바로 해결하세요.
×
컨텐츠로 건너뛰기
소개
🔥챌린지
수강후기
무료 강의
전체 강의
멤버십 강의
자료실
엑셀 위키
엑셀 함수
필수 단축키
기능 사전
응용 공식
VBA 코드
커뮤니티
FAQ
로그인
메뉴
소개
🔥챌린지
수강후기
무료 강의
전체 강의
멤버십 강의
자료실
엑셀 위키
엑셀 함수
필수 단축키
기능 사전
응용 공식
VBA 코드
커뮤니티
FAQ
로그인
오빠두엑셀 커뮤니티
커뮤니티 전체
공지사항
🏠
오빠두소식
커뮤니티
🖐️
가입인사
N
💬
자유게시판
N
실무스킬UP
🚨
엑셀질문답변
N
💾
엑셀정보공유
🎯
나의공부기록
N
두뇌풀가동
🤓
퀴즈게시판
N
오빠두교재Q&A
📚
진짜쓰는실무엑셀
고급필터 관련 오류 문의드립니다.
외윤내랑
Lv.4
📅 2023년 11월 23일 15:28
👁 조회 1,075
엑셀버전
M365
OS버전
윈도우10
안녕하세요.
고급필터 기능을 이용하여 간단 vbn을 만들어서 잘 사용하고 있었습니다.
백테이더를 일반 작성에서 표로 만들어 서식과 수식이 자동으로 작성되게 만든 이후 검색기능이 안됩니다.
매입을 알아오는 검색은 문제가 없는데 매출을 알아오는 검색에서는 일부만 발췌되어 금액이 이상하게 나옵니다.
매출 3건으로 검색되어야 하는데, 2건만 검색이 됩니다.
아니면 표이름으로 검색이 될수도 있는지 알고 싶습니다.
도움 부탁드립니다.
좋아요
0
댓글
7
스크랩
공유
외윤내랑
님의 최근 활동
외윤내랑
님의
게시글
댓글
[Q&A]
FILTER 관련 질문입니다.
(4)
02-26
[자게]
갑자기 나타난 수식 드롭다운 삭제 문의드립니다.
(3)
07-08
[자게]
"&H8000FFFF(-2147418113) 시스템 오류" 문의
(3)
06-04
[Q&A]
고급필터 관련 오류 문의드립니다.
(7)
11-23
[Q&A]
VBA IFERROR(VLOOKUP) 관련 문의 드립니다!
(4)
07-13
[Q&A]
감사합니다! 회사 컴퓨터를 포멧하면서 m365가 깔린것이 아닌 2024버전으로 깔렸었어요! 2024버전인데도 안되어서 이상했었는데 전체 삭제하고 M365로 다시 설치하니 잘 되네요!!!
03-11
[Q&A]
삭제 해보았는데도 안되더라구요.. 원본파일을 누락했었는데 한번 봐주실수 있을까요?ㅠㅠ
02-27
[자게]
감사합니다! 표로 설정되어 있어서 삭제가 안되는고 있었는데, 표설정먼저 해제하고 나니 삭제가 되었습니다! 수식의 자동합계라는것이라니 한번 공부해보겠습니다
07-08
[자게]
조언감사합니다! 디버깅했을때 작동자체가 안하길래 무엇이 문제인지 모르겠어서 vbn 내용이 2-3가지로 적기도 해서 전체 지워버리고 새로 작성하니 문제없이 작동하네요!! 내용이 날라간것도 아닌데, 작동자체는 안하면서 저런 오류창이 뜬거 같드라구요.
06-13
[Q&A]
감사합니다!! 알려주신 방법으로 사용하고 공부하겠습니다!!
11-27
외윤내랑
Lv.4
작성자
백테이더를 표로 만들어서 문제가 생겼다고 하기엔 매출 매입 똑같이 표로 만들었습니다.
매입은 문제가 없는데 매출에서 문제가 발생하는 중입니다.
백테이더를 표로 만들어서 문제가 생겼다고 하기엔 매출 매입 똑같이 표로 만들었습니다.<br /> <br /> 매입은 문제가 없는데 매출에서 문제가 발생하는 중입니다.
파일 첨부
저장
취소
2023.11.23
좋아요
삭제됨
사용자가 삭제한 댓글입니다.
2023.11.23
김재규
Lv.30
@외윤내랑
님
출고현황 필터링 결과:
출고현황과 입고현황 영역을 잘 보시기 바랍니다.
입고현황 영역 =OFFSET(입고현황!$B$5,0,0,COUNTA(입고현황!$B:$B),COUNTA(입고현황!$5:$5))
출고현황 영역 =OFFSET(출고현황!$B$5,0,0,COUNTA(출고현황!$B:$B),COUNTA(출고현황!$5:$5))
📄 출고현황-영역.png (90 KB)
📄 매입매출_처리현황_2311_V6-복사본-수정.xlsm (499 KB)
출고현황 필터링 결과:<br /> <br /> <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA50AAADuCAYAAAC6cmO4AAAgAElEQVR4Ae18X6t8S5LV73PMJ3Dox/4cwjBwQfFBQRz/gIh/GBpp6Ks44Ffop35qH67igw0iCvMwIC06NoJXQfDR91bHscfpmS6JU7XOiYoTmVWVFZlVq3Jt2ERmZOTK2BErY++s87v3y0GXIqAIKAKKgCKgCCgCioAioAgoAoqAIjApAl8m4QpWEVAEFAFFQBFQBBQBRUARUAQUAUVAETjo0CkSKAKKgCKgCCgCioAioAgoAoqAIqAITIuADp3TQitgRUARUAQUAUVAEVAEFAFFQBFQBBQBHTrFAUVAEVAEFAFFQBFQBBQBRUARUAQUgWkR0KFzWmgFrAgoAoqAIqAIKAKKgCKgCCgCioAioEOnOKAIKAKKgCKgCCgCioAioAgoAoqAIjAtAt1D55cvXw66FQNxQBwQB8QBcUAcEAfEAXFAHBAHxAFw4NbT6cVD5+Hww8OOtwV0x+eufGbFkGvvKF9c+arcqzOxxKsjrxSHH779iD2TaxXYylNeBxnjwuIzi58V+8tj7PrcPgbM7WP+bjt26tDZOFRrM+Qvnls2iGJ4fwxvife9tsoXV77uzfeq+eLVkVeKgw6dq/bcjHUY+cviM4uf1bza9bmr4/govGP+dOgs+QulNsP9H+CK4f0xXFlMlC+ufK3kxj1riVc6dII/DFxg8BHxXCkZ48LiM4uf1Xzb9bmr4/govGP+dOjUobPx19vVxFRB4TrEKF9c+Vq9n0fXE6906AR3GLjA4CPiuVIyxoXFZxY/q/m263NXx/FReMf86dB5+Cf/7Cd337tvBsWQ6wCifHHl61EviVvXFa+OvFIcfnj3O9ViOPu9qjzldZAxLiw+s/h5a+2/ZL/rc1+KC8t4Xf6e/tD5g8PX3/H/56fvHr7BX+a+/bOH73z5cvjqGxTO3zp81fg/6JrNN199OXz5zp89fIv5J2nB/NXhMHzb/Nkvxzff47O9P8vxub/z9Q9Of7WNMfty+PLVbx0Ob/H6tcPX3x7HP+wRvx8eDt989/Dli9k43SHi+7FjmyGG9Zu7zTfjw5cvjquHz/w75+PlGFf6v2e+PvP2/pgOcODqfTzD37mYDLxKaylyYnXSvR++/frXPv8f2Zt19yO2DHE4Plu/Rh1jcRvHEb/VMbglr+aj2a/2EbG5XYZ3+jsHjXONd0fj++irb05Ygevep8fH5bKPMd+rfY7rv73zT3l5GzvL0en9/+U5OJf63qiB2CvHbxr/LX5qBx7l2N8l2msfddzviXvakQ9vtRf8eP8u9+uG/Y7cQGKue1fd4981c+v215MfOs+TdUoEAv6pqH4k7Sypp8ScY33YvgXzV786/GrwtvmzD53npIgFufHSeXtuZ/tO7qPu49B5sgGhvXwrKD38Yxz5YviR//PY3q5/45UrvLEP/Mi/8/7lGAOnQu6cr4r4RYyY89iH/XnOPz5E/Av9Y1/ezkWs8yjJyytXJ5sv8uMeffsB782mvWefNw6nZ/A1/tQ23kV+fuLR6Z1rfP34sTfn6XPEoJ1Xe9bn8DGPn499zMt5P/Iwy7H9kHzUX33oHPwesu8oi+td30TvPDv/UcTH5Lz9g+W5fMuBe+97f87zc57f5+Vce6/4Z/toX2P/YfO8z32en4/nq9NHPpydT96/y69bL2LN8DfDrMvfUx86j4T1H2Fnv86eClP28jtL6hWHzj/9018dRu+7C2zzI6dFwvwl4+P0QZqPTT/7L52j8bN562PYiu3t+vMi4OId8vpmFz/28ANK69fqgPGR19v99HMt3rvmy8ehqn0TB95zHv/6Hff1fTmuerZbcHh51d63eP7ju+fXDl9/c/wXNvihIKu7DHE4e5deeEdaDFC/3t63b/8i5vQvaBo16jli0M6rPc9z+Hhpnx+f4YxniL97n5yNW04+fR/dduh82Pvh07PFf3l1jBf4iH24Opdv6w8eOh8W27hXz/5lW3uvoAaeyyvsTxw0bq7Oz7mvl/bY3PE3rrj3/tn5hOjQWcPbpz50xo+yE8mRvE9F9YM4x4J0/itZTDxIaZvhT/7kT4dvm3/Xr3qxEFzof/5YiB+rpzi5F9KKf17LFEPk/i554h9eep/l+csy8u/I0fN/rvLpw+ECF0b9Z+P86HNOn0fMgRmx4eVV/wPqWHPjX/di3f14/zDE4dp3JOrUsTadxwlx+fjr77PF4Nxfz3l7LoY8mc9vOcB3z6d+g4efvo9uO3Sufp+DZ63/vOft/eoOeW/2rr86l3H9yC18D8R3+mo/vV+f2smhM/r7ac77N8lxb/Xsjzk9foc/1XO/P8NHvWo/5/02H9x233vYz2/79PxbsedLj3e9efeO1eXvyQ+dh8PppfF+gHIHyU9F9UQO9yHo/wr6liwk2pHOgvnLX/7p8G3zrcDcm9Sr5p+ezTZ6JPLH5m+8aF1czN8Pe2yqj1i/jV20x7zj/zSCJoYu91fFvMg+8u+83/hwKFo7PicV5yfFIMZkRT/u2bcPk/eatJYDM56Xl1ftDyjkDO+S94PW6Z30uY4y1MMj14x/eC7jA571jZfug/6DK413S7JHn4ML/bw+h48f79GPOEfdx7v5vGaYXaNunP5iaPz0eb32n9c++/v87ZkcR1fnMq7vc/c29l7Xz3O52k/v16f22aHz3M832xOH3jj3/g3uDk5O5+uIn4v6+FTPndSrT7EptIl8eHuHgB9v39ntQ+fxfYNzz/X1t/p56vL39IfOZCNcIMNbgr989/BV+B8HHfWf/+NnC+Yf//JPhm+bb5uyOsmf8U4fCiDrexziS6dBzHdy5y9ifEx95zv2P88AyTsvtff1jx9ZHDG8nU+f84D/4VJefGOBRjE+4x+K9XsuYw6L/HQ58s/Bw/m5cfAxubl9zws5zctaDtz8vKnP5/l5al7dnK9TvT2rhf552/l66ji8Hy6/e/ja/kdJ7zXo81/Ujv9judvqHHi1LAY35/Ujh8t8vGLvIG63y5yH7++b94PZ0e7aQ+ezv8/fn+/0Ll2dy7g+3vv2vn8bc/vqPaffHP+HOg+L7R175f0ZruEy1nnn3obfiC5OkQ/3HjpxkL8pJ86fkXl1+4vi0ImXf/7yw0e9BRKF4Kg7zTsRPyYegbdg/tEf//Ls/oe/848PuH/wD/7R4e9//weHv/vb3zv8zb/1t8/sbJ7Nn3/oPD1LVsg+/dJ5+6ETB87jP5M6zX//2Dqu3SM6Rww/PjaQ+zrZiPnVG/1yjOt8Pb4Anp/zM/M1A/teDszwaS0mSx04fxfU5+2Z43B8R+KX9fNnP4/Lfdx5XAzOn+lT3cQH8en/JPqSdfD0r5SOPyAj18d3zLWHzqVxcTnB4a0l/feez+3j+PZ5n2T7CN9Yz+Snj1+vnT3P+79CdAdLw8Bz+h+zTM/43L2Y3DIW4zd+6PzMtVv8uMe2Ln8Uh85GoE+F9b0InQrXe//tg//jYz4mHgmwYP7i//3y0/2Df/g7Z4fN3/prf+OTjc2z+VMPnafnzP67meMzfDzjsX966eKvaW8S/wMMewEdxz8OkXH+Md4f8crHET+TTx/Dqw9/Da415r/F6CzO7oeRUIzPcvNp7HKMfbzvbe+ar3vjls2/nQPGsWyPZv/k/TY+Zv6t1LHw6qO2uVx82pOn2KP+Nvb5Rx39yNXTxiG+M0917S0eX/1W+y80Db7GD0vPtcfF4MKh09Xyx/n4wRUfs347vreBcXx3fHz3oLbYv1Y6td9+rIbd5fg8Pi6XfXyP1em77yE+9/aT/wPByc5qxUP8dJw/xg0ccd8rVt+8z27Oeb0E75Icued8z88J5zmeG76vlek3AmL9FjP8MPTZr+Mh3v/Lw882MdYz+nX5ozh0Hovlrb98xcDnG+d4YPq/v/jjQ3b/nb/324e/8lf/+uEv/qW/nI7bHEvG1EOn2/zxmY79Kw8s7+Q+FovsY2kU32KQxc90HDEc28g5p5Ji/J7D3tiYD3nO+li75mskVpfmDHMALx1wo/PCvuTDs4yz8Oo8Z6N7sl13WeIQeXMeF9SQU3wiX88ONLD9kI+LwXX5tGd9nI8fcYo5aPdPz9X48eP90Pl2CPMfsThsQl6Oz+PjctnHtzi5Z32Iz6ea/R571PKOfIifZ/6cYnvDfn6rCw3etf8Ycs7xxz/3uT/tfbbY7v27/LTu6UeU1nnH62/h3b3PW5c/okPnvQHOX6jHQ+cf/t8/PrTuP/fn/0JzzOZYMnTo/Ek3Rs8fw7FCk3Oq98LsjY35MFJMjLMtvpv+VfM1EqtLc4Y5EF/6L3LoZODVec5G92T/0MkQh8jt87igHt3+kWq4j6sx1+XTnvVxPiK2t8jjc33+sRiHyUtYsLscn8fH5bKPb9wNh87le27w0Lncz4pDZ3xf4Uen1r8QOVvzkfXg0r548Hg8dIa4xRr9qH5dTSA6dPoTvm9/LsI5ifIX6nEz/MEf/r/D6G3J0KHzJ8Pxs7g/PoY5Zy5t8DdO3fQL4OlletOcMd96vlu8R/nOnK9eTEbHbueA5TPnwbW1bNTX2fNYeHX+LrjyA/fTx0D/0Mm4v87j4utOztfWP8cznj2OC9fl0571cT762F7bbuTg9C65/KP8bYfOx/L3uhy+1bPTX4YeksvTodN/j360/V+bP3L8ED8/1a4Glz4dLI9+j73jPp75sfXg3I/Z78Cb8YkOnTU1geLQOZc0VgT+9x/+0fBt8x976Jwbn2s2kWL4+BxckyfYKF9c+ULenl2KV0deKQ7HQ+ezv1eVp7wOMsaFxWcWP6vfNbs+d3UcH4VXlz8dOt9+7fxf/+ePDqO3JUOHzp8Mx8/irhjmL/9ZBcbiPcp35WttrmZxYAauePVx6Nx9fzFwgcHHGfv0EiZjXFh8ZvHzEkduHd/1uW+N07Pa1+VPh863A8///INfHEZvS4YOnT8Zjp/FXTFce5CxeI/yXflam6tnfQllfolXH4fO3fcXAxcYfMz22WwdY1xYfGbxs5pjuz53dRwfhVeXPx063w48P//fvziM3pYMHTp/Mhw/i7tiuPYgY/Ee5bvytTZXj3rJjKwrXn0cOnffXwxcYPBxZB/eO4cxLiw+s/h5L4fi/F2fO8aBtV+XPx063w48FtB7bh0674ufxX73GK4sRvdwHXOVLx0+I2fBjXvkK/DqnufHXPY44DnukbNjcI9vmDvbx7jHVvTxbPfI1XG5x1fMXeEz1rpHrvCzmmf3PC/mMj53dRwfhYcc3COP+dOh81CRRG2G+z/AFcP7Y1jB5WsxlC+ufF2b10fbiVdHXikOP6T4IVJ5yusgY1xYfGbxs/pdsutzV8fxUXjH/BUfOg1Ut2IgDogD4oA4IA6IA+KAOCAOiAPigDhgHLj16s4YAbzVgWe1t2f/xc8Puu+Iwc78eVZe9/wS57XfZ9Q88erIK8Xh8PYD9gyOVWIqT3kdtLiwXSy5ZPGzcp8ZFiOn2PbATH9H8tetIiOAMx9wJfauRaCyqOzMn5VcrVpLnM8/tir3xI5Y4pUOneA9AxcYfEQ8V0qLC9vFkksWP6v5xsgptj0w09+R/HWryAjgzAdcib1rEagsKjvzZyVXq9YS53XorNz/wBKvdOhk4oL4mtdBxvc5Sy5Z/MQ+rpKMnKr63noFnJH86dDZyPyuRaCqmBjOCCEb6ZB6QQTE+fxjq3JP7IglXunQCd4zcIHBR8RzpbS4sF0suWTxs5pvjJxi2wMz/R3JX7eKjADOfMCV2LsWgcqisjN/VnK1ai1xXofOyv0PLPFKh04mLoiveR1kfJ+z5JLFT+zjKsnIqarvrVfAGcmfDp2NzO9aBKqKieGMELKRDqkXRECczz+2KvfEjljilQ6d4D0DFxh8RDxXSosL28WSSxY/q/nGyCm2PTDT35H8davICODMB1yJ/YgiYGvi9ps78wV2GIvSz39U23xivHxsvf/Z89xi67GesW3P8iiuaN3XPfCKVzp0Yn8zcIHBR8RzpbS4sF0suWTxs5pvz8gp8wm353vmK+ziWOwbjrf1bb8G2hj3fWBA9wwye85LfnWrSAaIYMSxKn3L4bie2bXWzDBatj199Qbr4Zkfftz3fdvb+DZsIOOY6bMxb1fdtvXYruiz7/s2+OefD+Mm0fbjz942n6s5ILzXPUxem1vxSodOcIWBCww+Ip4rpcXlma/MP5ZcsvhZzbcsZ4/kWPTH933bfGz1TR/Hes8UbX0f7Sh7eCvH4Ncta3arSARs9av0meOGjduPt9b0Nmi3bFt6m2dj1RushxfXs76//Vyv922zsX607fX9WHXbfGG7os++79t4LtPhhs5kZuvHn7FtPldzQHg6dIpXOnSiDjBwgcFHxHOltLg842V+4Y7+seSSxc9qvtlzP9MV/fF934bPpsMNncnM1o/7drT1fbRN4vZzH92Gf7f40c14BGz1b9VHB+P8OG79aHOpn2FAh7mQUY/1qjdYD8988eO+79uXbFq2mHdpHHYV0tZiu6LPvu/b4Ijp4o0xxmevyLswdND0HLD94fu7thWHzz+KPiMXlKe8fllcnvnK/GPJ5Zif3x6+/xvfOX5//JmvDt//acxbb9zGvj787OfHOT8+4fy60/m9+bPvfXX49bdvne8cfvNH7Tk//g37Hvrq8OMTrsfI2lnOHsmx6I/v+7b5aP3sxtg1zxEx41yMR3kN9gob+HXLWt0q0gP0Y74dgwZnMhvTQY+2l5ibYWIebPw8387GvQ5tkx7T2tkmmanzfvt1Wr5Aj3k2B7o439v4sZltW5Ptij77vm/752rpvQ1D255jJh+EHT8K9uiLV8c8Kw75++nZ6oLylNcli8szX5l/LLkc8vOnXx++/71v397ZP/vRV4ffPLXf91Nn/Gc/+vbw4++dDp0//frw67/xzQfO6VDpcTLs1pyffe/rLQ6d2AsZ7zAGaTaXbtiahC10WAMS+kfLEX+6VaQFGPW39mOg4vw4bv1oc6mfYUCHuZBRj/XeN92Vv9qstjf/sSbakNBHeWk82t/Tt7XYruiz7/s2nst02Y1xJmnPcU++NTf/WNs9LuKVDp3YAwxcYPAR8VwpLS7PfGX+seRy2E87MH758nZoxF8tzziRjf/0m7e/cL4fOn/0tfsr6TeH3zwdQN9xfmSH0o+/qL79FbMzZ6dDp+Utu6v3ia1hF2Q1/ijeiD/dKpIBXqPzNr7derARmzgn9ltrmR62kLD1fWu/b7pFh87WmpkeupZs+Q771nil3tZiu6LPvu/bl57rFttLWKvGzefK/AtLh1DjgHilQydqAQMXGHxEPFdKi8szX5l/LLkc8/Pbw/f/zFeHH3/6Z7V472Tj3x5+drK/9tD5s+/ZP6k9/kX1Fz/9+ngo1aGzuxVaXDR9dnfBnngwe85L7narSASMfYBHPfqQsIOM+tiHnZfR5lL/mrk9DBtbWdBtLVuzdUdf4F9Lwh7jrT70M6StzXZFn33ft/1zmT7efpylbc8wgwfCxEfAnlK80qETNYCBCww+Ip4rpcXlma/MP5ZcDvl5dvBL3i3JuB0gba2P2w6tF/55rf3TXX/otH/G25mz0186bT98xPIjrtk+MbvsyvQZZmaX4a3UjfiUR+HkdQTMAoEH9GOZDuPZGHQ9GX0xW2BmYxGrZdvTryzotpb5kq0Z9VkfOkiPYzrcXj+7bWsyXohV9D/2wUHGZ8x8tuebzQnhJx8Hi/4lxaNiL17p0AnuMXCBwUfEc6W0uDzzlfnHkssRPz8dIN/+Wezpr5s/Pxzy8Y/3z/tfOn9+OPz4dBj9+B8JfeD84ufWPn1D2l9WT++rz3OO2MyHTuO35QK357vp4pXpog36LduWHvO8vMXWz5vVHvHncxSddyOAbjp10559ZUHHWrZuvDHWk/AXsme7asx8eaWr9Tymz262Z7dnWMUNrfPx8n/1WIhXOnSC4wxcYPAR8VwpLS5sF0suK/20/0lQBS+qcHq+MHGq5avpszvulcwGumjb6pv9M10j/nSfYATwmQJyjy/27L3NorHLH8078+ce7j1qrjh/mdPa97fHSLzSoRP7hoELDD4iniulxYXtYskli5/VfGPkFNsemOnvSP66VWQEcOYDrsTetQhUFpWd+bOSq1VrifO3H6gq98urYolXOnSC2wxcYPAR8VwpLS5sF0suWfys5hsjp9j2wEx/R/LXrSIjgDMfcCX2rkWgsqjszJ+VXK1aS5zXobNy/wNLvNKhk4kL4mteBxnf5yy5ZPET+7hKMnKq6nvrFXBG8qdDZyPzuxaBqmJiOCOEbKRD6gUREOfzj63KPbEjlnilQyd4z8AFBh8Rz5XS4sJ2seSSxc9qvjFyim0PzPR3JH/dKjICOPMBV2LvWgQqi8rO/FnJ1aq1xHkdOiv3P7DEKx06mbggvuZ1kPF9zpJLFj+xj6skI6eqvrdeAWckfzp0NjK/axGoKiaGM0LIRjqkXhABcT7/2KrcEztiiVc6dIL3DFxg8BHxXCktLmwXSy5Z/KzmGyOn2PbATH9H8tetIgaoWzEQB8QBcUAcEAfEAXFAHBAHxAFxQBwAB2491F48dN4K+Cr2FtDqX3V2w7MY6uKJgDivv3TOqFHilf7SCV4xcIHBR8RzpbS4sF0suWTxs5pvjJxi2wMz/R3JX7eKjADOfMCV2LsWgcqisjN/VnK1ai1xXofOyv0PLPFKh04mLoiveR1kfJ+z5JLFT+zjKsnIqarvrVfAGcmfDp2NzO9aBKqKieGMELKRDqkXRECczz+2KvfEjljilQ6d4D0DFxh8RDxXSosL28WSSxY/q/nGyCm2PTDT35H8davICODMB1yJvWsRqCwqO/NnJVer1hLndeis3P/AEq906GTigvia10HG9zlLLln8xD6ukoycqvreegWckfzp0NnI/K5FoKqYGM4IIRvpkHpBBMT5/GOrck/siCVe6dAJ3jNwgcFHxHOltLiwXSy5ZPGzmm+MnGLbAzP9Hclft4qMAM58wJXYuxaByqKyM39WcrVqLXFeh87K/Q8s8UqHTiYuiK95HWR8n7PkksVP7OMqycipqu+tV8AZyZ8OnY3MP6II2Jq4/abOfIEdxqL08x/VNp908UQAHHoUX7Ru/rHHHhfxSodOcLjHBRvDDXuTcQ5sosxsoYu2EbO3nh/buW0xY7t6eX6mXLL4WR0zRk6x7YGZ/o7kr1tFMkDT4fYPA12cc6veY/p2xMVYS49xyFv9MPvqDdbDi+v5vm+3MGAD6e1Mh9vrZ7dtzWuulh308N1L4MIGfZNe5+egDVv0vT3mYwy2PX0ci3geA+1oE/vAhD368AsS4+hHnJYe87w02xYnWmPQ+3XQBhZs0DfpdbD3EraZDvMxBtuePo7ZXD8va0eb2AemnwufvMR4pgMGxmAbJca9jDbXYsV5hhl1EatlA7tsPnS9ubCpkHGdXr83VuFLhhHXzGxeXdeKQdT7vm/7+Hg92pDertVu2bb0LZxd9BaXqusSlo3j9mtCF+f39Az5Mf8Z/Kz2MebR51rt54/ASP66VSQCtvpV+izEho3bj0MX1/Y2aEcb9CEzOxur3mA9vLie9f3t53q9b5uN9aNtr+/HqtvmyzVXyw56yAwrG/M63/bzox59SNiiDxn11o9jLR3mxvE43/q4W3N6euBBwjb2oYe08RYHWmPQQ2bzszGv820/P+rRh4Qt+pBRb/041tJhbhyP862PuzWnpwceJGxjv6ePtpf6wIoyzrPxa3UtW79GhuXHq9pxnV7fj/l2lS8Zzqp1srWfRdeKQdT7vm/75/B6tCG9nbVNH+9og34LA+O7SovLvZfPQQsrroM+JOahDxn11rcxhnyx+Fkdy5g75FCSIwIj+etWkQjY6t+qj+GM8+O49Vs2Lb3HiDboQ8LW961dvcF6eHE93/dtj+H1aEN6O9++NO5t723bWtde0db3fTviZWNe59t+btSjDwlb9CEv6TF+SQIPMrOPY7GPOVGPPmTLDnpIs+/lPI77vm9HjGzM63zbz4169CFhiz7kJT3GL0ngQWb2cSz2MSfq0Yds2fX0fq5vY841EvMgMSf2oY8SdpBx3Pq9scx+VBfX6fUxBjm65i3zVq51i18rbXsxsDHc3qfWHK9HG/Ka+d7GtzMMP75r2+JSdfWw4hj6kPABfciot76NMeSLxc/qWMbcIYeSHBEYyV+3ivQA/ZhvY6PHkGU2poMebS89Buy8Lq7l56IdbbJ+prP51RvsEh58jmvHPnCgxzzTQwcb6LyNH5vZtjVvuWAPibnw3Us/hjakn+/nRD3sTWIMEmPoQ17SYxzS5sXbxqCDXSazNTHPj/k2sCNetInjmHeJD4YDTnlb08cb45iDfpx/7TzgQAIPfchLeoxD2rx42xh0sMtktibm+THfBnbEizZ+PBvzOt/28y61MQ/S25su00cb6/fsemMeq6KNtVoSa9g4bKCbLVevN/t5RvBHYtCa4/XWxh398nZxLOvfap9hvKLO4lJ19bDiGPqQ8AF9yKi3vo09Ihe2brx7fjzKz55PI2PxmS89l43r4o3ASP66GW8BRv2t/RjiOD+OW79l09J7jGhzqY/1Rjbdyjn2HFgPbUjoo7w0Hu3v6dtat17ZnEwH3Gws00X7aIM+5D32hhFxgAeJcUjoveyNmZ0ft7a/b8GBrc2/Jt+ZXaYDVjaW6aJ9tEEf8h57w4g4wIPEOCT0XvbGzM6PW9vft+L4uR43ruNxe+1rMbBuxLplfpw7qw+fWhLrxnHoZ0qsOXONZ8duxcD02W3P05uD54UNJPSQGXbPFvMkP/7nZhavqquHFcfQh4QP6ENGvfVtjCGHLH5WxzLmDjmU5IjASP66VSQDvEbnbXy7FcZ7bEbm+jm+7f0zffUGu4TXWjPTQ9eSrbVg3xqv1Ntat17ZnEwH3Gws00X7aIM+5Kh9nId+lH4d3/Z2LT1sWuNe79uY15Jme03+M7tMB6xsLNNF+2iDPuSofXs0RI8AACAASURBVJyHfpR+Hd/2di09bFrjXu/bmBflJZtL4xHP+jYn3pkddHGNODeOt+ZBP0PCh5bEmhi3vm9jfIZctc4M36swr4kBbEzijut7GxuL/ZY99LBH38vemLfbrW1xqbp6WHEMfUj4gD5k1FvfxhjyxOJndSxj7pBDSY4IjOSvW0UiYOwjLFGPPiTsIKM+9mHnZcumpe/NxRxIb4u2jVVvsEt4tmbrjnPhX0vCHuOtPvQzpK1965XNyXTAzca8zrdtDvqQEedWvccEVkvXG4/rZhjRBn1I4KMPCf0lafbX8CCzy3TAysa8zrdtDvqQEedWvccEVkvXG4/rZhjRBn1I4KMPCX1LXmMXbWLfY7fGoIdszcnGzTbTZzqPW92O68V+5mdmM9uvanwGvF6cMQaJ54l900PXkpgLCbtWH3qT0daP7dy2uFRdPaw4hj4kfEAfMuqtb2MMOWPxszqWMXfIoSRHBEby160iEdD68UZovD7TYTwbg64nbX52tfTRFut7e69DG/OsX73BLuG11oz6rA8dpF/LdLi9fnbb1rz1yubAdy89rtdfmt+ad4/e5l7ywePD/pLu3meJPmV43gcbv4YTmV22lseK437M2n7cj1Xp4xqG69fJ2plN1MV+XMfjmi1u6NH3EmNe2rjvt9qXcDCvhef1HsvrDSP2e7gtW8yplnG92G/5n9lV+jYbv9LXWVi9GPTGvD/RzvrQQcIeYz0JW8iIAf3u0uJSdUWsrG+6Cj1D3uw5Gfys9jHmt4pfwlkTgZH8davICOCaR52/yqOKgK0b72s2OvyFvGbObBvzRRdPBJ6JO7O5KfyP/1ZrdizEq2OsFYf2jxXgoMUouzHekogtZMvuGn0FxjXrsNlYXGZds7BZcsniZzVnZ+V9Fk+Fex6Bkfx1q8gI4LlLvL1di0BlUdmZP4zMF+fXHcQq99mzY4lXOnSCowxcYPAR8VwpLS4zrlm45itLLln8rObbzNzP4KowzyMwkr9uFRkBPHeJt7drEagsKjvzh5H54rwOnZX7H1jilQ6dTFwQX/M6yPg+Z8kli5/Yx1WSkVOM33azfB7Jnw6djWzsWgSqionhjBCykQ6pF0RAnM8/tir3xI5Y4pUOneA9AxcYfEQ8V0qLC9vFkksWP6v5xsgptj0w09+R/HWryAjgzAdcib1rEagsKjvzZyVXq9YS53XorNz/wBKvdOhk4oL4mtdBxvc5Sy5Z/MQ+rpKMnKr63noFnJH86dDZyPyuRaCqmBjOCCEb6ZB6QQTE+fxjq3JP7IglXunQCd4zcIHBR8RzpbS4sF0suWTxs5pvjJxi2wMz/R3JX7eKjADOfMCV2LsWgcqisjN/VnK1ai1xXofOyv0PLPFKh04mLoiveR1kfJ+z5JLFT+zjKsnIqarvrVfAGcnfxUOngepWDMQBcUAcEAfEAXFAHBAHxAFxQBwQB4wDt17dGSOAtzrwrPb27FW/5uyKszN/npXXPb/E+fwX/l33b9Vzi1f6Sye4xMAFBh8Rz5XS4sJ2seSSxc9qvjFyim0PzPR3JH/dKjICOPMBV2LvWgQqi8rO/FnJ1aq1xHkdOiv3P7DEKx06mbggvuZ1kPF9zpJLFj+xj6skI6eqvrdeAWckfzp0NjK/axGoKiaGM0LIRjqkXhABcT7/2KrcEztiiVc6dIL3DFxg8BHxXCktLmwXSy5Z/KzmGyOn2PbATH9H8tetIiOAMx9wJfauRaCyqOzMn5VcrVpLnNehs3L/A0u80qGTiQvia14HGd/nLLlk8RP7uEoycqrqe+sVcEbyp0NnI/O7FoGqYmI4I4RspEPqBREQ5/OPrco9sSOWeKVDJ3jPwAUGHxHPldLiwnax5JLFz2q+MXKKbQ/M9Hckf90qMgI48wFXYu9aBCqLys78WcnVqrXEeR06K/c/sMQrHTqZuCC+5nWQ8X3OkksWP7GPqyQjp6q+t14BZyR/OnQ2Mv+IImBr4vabOvMFdhiL0s9/VNt80sUTAXDoUXzRuvnHHntcxCsdOsHhHhdsDDfsTcY5sIkys4Uu2kbM3np+bOe2xYzt6uX5mXLJ4md1zBg5xbYHZvo7kr9uFckATYfbPwx0cc6teo/p2xEXYy09xr3MbHv+VW+wHp754cd937e9jW/DBjKOmT4b83bVbVvvmqtlB73JeAMXNuib9Lo4rzUW52PeNXqsiTl+DT/ft6NN7AMzzvFr+Dle35rj9VnbMFocaI1B79dHG1iwQd+k18HeS9hmOszHGGx7+jhmc/28rB1tYh+Yfi588hLjmQ4YGINtlBj3MtpcixXnGWbURayWDeyy+dD15sKmQsZ1ev3eWIUvGUZcM7N5dV0rBlHv+77t4+P1aEN6u1a7ZdvSt3B20VtcKi7DwZ3hYcxL2GU6G+vpGfJj/jP4We2jPbcu3giM5K+b8QjY6lfps9AbNm4/Dl1c29ug3bKNc33f2tUbrIcX17O+v/1cr/dts7F+tO31/Vh123y55mrZQQ+ZYWVjXufbfn7Uow8JW/Qho976caylw9w4HudbH3drTk8PPEjYxj70kDbe4kBrDHrIbH425nW+7edHPfqQsEUfMuqtH8daOsyN43G+9XG35vT0wIOEbez39NH2Uh9YUcZ5Nn6trmXr18iw/HhVO67T6/sx367yJcNZtU629rPoWjGIet/3bf8cXo82pLeztunjHW3Qb2FgfFdpcbn3ihixb/iZLtPDDhK++b61GfLF4md1LH2ukD9JngiM5K9bRSJgq3+rPoY0zo/j1m/ZtPTXYPTm2lj1BuvhxfV837c9htejDentfPvSuLe9t21rXXtFW9/37YiXjXmdb/u5UY8+JGzRh7ykx/glCTzIzD6OxT7mRD36kC076CHNvpfzOO77vh0xsjGv820/N+rRh4Qt+pCX9Bi/JIEHmdnHsdjHnKhHH7Jl19P7ub6NOddIzIPEnNiHPkrYQcZx6/fGMvtRXVyn18cY5Oiat8xbudYtfq207cXAxnB7n1pzvB5tyGvmexvfzjD8+K5ti0v1lWFmOls36tGHhG++b22GfLH4WR1LnyvkT5InAiP561aRHqAf820LV+xnOrPBjXH0IX3oTZddXo95Xvo53tb03i4bq95gl/C8P97W9L6PNvSYZ3roYAOdt/FjM9u25i0X7CExF7576cfQhvTz/Zyoh71JjEFiDH3IS3qMQ9q8eNsYdLDLZLYm5vkx3wZ2xIs2cRzzLvHBcMApb2v6eGMcc9CP86+dBxxI4KEPeUmPcUibF28bgw52mczWxDw/5tvAjnjRxo9nY17n237epTbmQXp702X6aGP9nl1vzGNVtLFWS2ING4cNdLPl6vVmP88I/kgMWnO83tq4o1/eLo5l/VvtM4xX1FlcKi7kqYXnx72Nb+N95SV883bWfkQubN149/x4lJ89n0bG4jNfei4b18UbgZH8dTPeAoz6W/sxxHF+HLd+y6alvwYjzvV9a49supVzvI9oQ7b8uDTemjeit7VuvbI5mQ642Vimi/bRBn3Ie+wNI+IADxLjkNB72RszOz9ubX/fggNbm39NnjO7TAesbCzTRftogz7kPfaGEXGAB4lxSOi97I2ZnR+3tr9vxfFzPW5cx+P22tdiYN2Idcv8OHdWHz61JNaN49DPlFhz5hrPjt2Kgemz256nNwfPCxtI6CEz7J4t5kl+/M/NLF7V1zWYsIGED+hDRr31bYwhhyx+Vscy5g45lOSIwEj+ulUkA7xG5218uxXGe2yumYt1o22vb2PVG+wSXmvNTA9dS7bWgn1rvFJva916ZXMyHXCzsUwX7aMN+pCj9nEe+lH6dXzb27X0sGmNe71vY15Lmu01+c/sMh2wsrFMF+2jDfqQo/ZxHvpR+nV829u19LBpjXu9b2NelJdsLo1HPOvbnHhndtDFNeLcON6aB/0MCR9aEmti3Pq+jfEZctU6M3yvwrwmBrAxiTuu721sLPZb9tDDHn0ve2Pebre2xaX6ugYTNpDwAX3IqLe+jTHkicXP6ljG3CGHkhwRGMlft4pEwNhHWKIefUjYQUZ97MPOy5ZNS+/noh1te30bq95gl/BszdYd58K/loQ9xlt96GdIW/vWK5uT6YCbjXmdb9sc9CEjzq16jwmslq43HtfNMKIN+pDARx8S+kvS7K/hQWaX6YCVjXmdb9sc9CEjzq16jwmslq43HtfNMKIN+pDARx8S+pa8xi7axL7Hbo1BD9mak42bbabPdB63uh3Xi/3Mz8xmtl/V+Ax4vThjDBLPE/umh64lMRcSdq0+9CajrR/buW1xufeKGLFv+FGHPiR8QB8y6oHFkDN7BgY/q32MuUMOJTkiMJK/bhWJgNaPN0Lj9ZkO49kYdD1p87Orpb/WFn5FHOtXb7BLeK01oz7rQwfp1zIdbq+f3bY1b72yOfDdS4/r9Zfmt+bdo7e5l3zw+LC/pLv3WaJPGZ73wcav4URml63lseK4H7O2H/djVfq4huH6dbJ2ZhN1sR/X8bhmixt69L3EmJc27vut9iUczGvheb3H8nrDiP0ebssWc6plXC/2W/5ndpW+zcav9HUWVi8GvTHvT7SzPnSQsMdYT8IWMmJAv7u0uFRcPhfAi9iZjdmO6BnyZs/F4Ge1jzHv4IMkRwRG8tetIiOAHKG67OWjioCtG+9rNjr8hbxmzmwb80UXTwSeiTuzuSn8j/9Wa3YsxKtjrBWH9o8V4KDFKLsx3pKILWTL7hp9BcY167DZWFxmXbOwWXLJ4mc1Z2flfRZPhXsegZH8davICOC5S7y9XYtAZVHZmT+MzBfn1x3EKvfZs2OJVzp0gqMMXGDwEfFcKS0uM65ZuOYrSy5Z/Kzm28zcz+CqMM8jMJK/bhUZATx3ibe3axGoLCo784eR+eK8Dp2V+x9Y4pUOnUxcEF/zOsj4PmfJJYuf2MdVkpFTjN92s3weyZ8OnY1s7FoEqoqJ4YwQspEOqRdEQJzPP7Yq98SOWOKVDp3gPQMXGHxEPFdKiwvbxZJLFj+r+cbIKbY9MNPfkfx1q8gI4MwHXIm9axGoLCo782clV6vWEud16Kzc/8ASr3ToZOKC+JrXQcb3OUsuWfzEPq6SjJyq+t56BZyR/OnQ2cj8rkWgqpgYzgghG+mQekEExPn8Y6tyT+yIJV7p0AneM3CBwUfEc6W0uLBdLLlk8bOab4ycYtsDM/0dyV+3iowAznzAldi7FoHKorIzf1ZytWotcV6Hzsr9DyzxSodOJi6Ir3kdZHyfs+SSxU/s4yrJyKmq761XwBnJ38VDp4HqVgzEAXFAHBAHxAFxQBwQB8QBcUAcEAeMA7de3RkjgLc68Kz29uxVv+bsirMzf56V1z2/xPn8F/5d92/Vc4tX+ksnuMTABQYfEc+V0uLCdrHkksXPar4xcoptD8z0dyR/3SoyAjjzAVdi71oEKovKzvxZydWqtcR5HTor9z+wxCsdOpm4IL7mdZDxfc6SSxY/sY+rJCOnqr63XgFnJH86dDYyv2sRqComhjNCyEY6pF4QAXE+/9iq3BM7YolXOnSC9wxcYPAR8VwpLS5sF0suWfys5hsjp9j2wEx/R/LXrSIjgDMfcCX2rkWgsqjszJ+VXK1aS5zXobNy/wNLvNKhk4kL4mteBxnf5yy5ZPET+7hKMnKq6nvrFXBG8qdDZyPzuxaBqmJiOCOEbKRD6gUREOfzj63KPbEjlnilQyd4z8AFBh8Rz5XS4sJ2seSSxc9qvjFyim0PzPR3JH/dKjICOPMBV2LvWgQqi8rO/FnJ1aq1xHkdOiv3P7DEKx06mbggvuZ1kPF9zpJLFj+xj6skI6eqvrdeAWckfzp0NjL/iCJga+L2mzrzBXYYi9LPf1TbfNLFEwFw6FF80br5xx57XMQrHTrB4R4XbAw37E3GObCJMrOFLtpGzN56fmzntsWM7erl+ZlyyeJndcwYOcW2B2b6O5K/bhXJAE2H2z8MdHHOrXqP6dsRF2MtPcYhW37YOMZgC131BuvhmQ9+3Pd929v4Nmwg45jpszFvV9229a65WnbQm4w3cGGDvkmvi/NaY3E+5l2jx5qY49fw83072sQ+MOMcv4af4/WtOV6ftQ2jxYHWGPR+fbSBBRv0TXod7L2EbabDfIzBtqePYzbXz8va0Sb2gennwicvMZ7pgIEx2EaJcS+jzbVYcZ5hRl3EatnALpsPXW8ubCpkXKfX741V+JJhxDUzm1fXtWIQ9b7v2z4+Xo82pLdrtVu2LX0LZxe9xaXquoRl47j9mtDF+T09Q37MfwY/q32MefS5Vvv5IzCSv24ViYCtfpU+C7Fh4/bj0MW1vQ3a0SbrZ7rqDdbDs/X9uPX93RuDndlkOHGu789smy/XXC076CEzrGzM63zbz4969CFhiz5k1Fs/jrV0mBvH43zr427N6emBBwnb2Ice0sZbfGiNQQ+Zzc/GvM63/fyoRx8StuhDRr3141hLh7lxPM63Pu7WnJ4eeJCwjf2ePtpe6gMryjjPxq/VtWz9GhmWH69qx3V6fT/m21W+ZDir1snWfhZdKwZR7/u+7Z/D69GG9HbWNn28ow36LQyM7yotLvdePgctrLgO+pCYhz5k1FvfxhjyxeJndSxj7pBDSY4IjOSvW0UiYKt/qz6GM86P49Zv2bT0HiPa+D7akJhn/eoN1sOL6/m+b3sMr0cb0tv59qVxb3tv29a69oq2vu/bES8b8zrf9nOjHn1I2KIPeUmP8UsSeJCZfRyLfcyJevQhW3bQQ5p9L+dx3Pd9O2JkY17n235u1KMPCVv0IS/pMX5JAg8ys49jsY85UY8+ZMuup/dzfRtzrpGYB4k5sQ99lLCDjOPW741l9qO6uE6vjzHI0TVvmbdyrVv8Wmnbi4GN4fY+teZ4PdqQ18z3Nr6dYfjxXdsWl6qrhxXH0IeED+hDRr31bYwhXyx+Vscy5g45lOSIwEj+ulWkB+jHfBsbPYYsszEd9Gh76TFg53VxLT8X7Z69nx/xrV+9wS7hwee4duwDB3rMMz10sIHO2/ixmW1b85YL9pCYC9+99GNoQ/r5fk7Uw94kxiAxhj7kJT3GIW1evG0MOthlMlsT8/yYbwM74kWbOI55l/hgOOCUtzV9vDGOOejH+dfOAw4k8NCHvKTHOKTNi7eNQQe7TGZrYp4f821gR7xo48ezMa/zbT/vUhvzIL296TJ9tLF+z6435rEq2lirJbGGjcMGutly9Xqzn2cEfyQGrTleb23c0S9vF8ey/q32GcYr6iwuVdclLBvH7deELs7v6R+RC+8P2j0/zKY3zjKGZ/Wy57vZ6eKNwEj+uhlvAUb9rf0Y4jg/jlu/ZdPSX4Ph5/o21uttlmcYM5/hB9qQ0Ed5aTza39O3tW69sjmZDrjZWKaL9tEGfch77A0j4gAPEuOQ0HvZGzM7P25tf9+CA1ubf02+M7tMB6xsLNNF+2iDPuQ99oYRcYAHiXFI6L3sjZmdH7e2v2/F8XM9blzH4/ba12Jg3Yh1y/w4d1YfPrUk1o3j0M+UWHPmGs+O3YqB6bPbnqc3B88LG0joITPsni3mSX78z80sXlVXDyuOoQ8JH9CHjHrr2xhDDln8rI5lzB1yKMkRgZH8datIBniNztv4diuM99hcM9fWzexMF2/4aPrqDXYJr7VmpoeuJVtrwb41Xqm3tW69sjmZDrjZWKaL9tEGfchR+zgP/Sj9Or7t7Vp62LTGvd63Ma8lzfaa/Gd2mQ5Y2Vimi/bRBn3IUfs4D/0o/Tq+7e1aeti0xr3etzEvyks2l8YjnvVtTrwzO+jiGnFuHG/Ng36GhA8tiTUxbn3fxvgMuWqdGb5XYV4TA9iYxB3X9zY2Fvste+hhj76XvTFvt1vb4lJ19bDiGPqQ8AF9yKi3vo0x5InFz+pYxtwhh5IcERjJX7eKRMDYR1iiHn1I2EFGfezDzsuWTUt/zdyejeFWb7BLeLZm645z4V9Lwh7jrT70M6StfeuVzcl0wM3GvM63bQ76kBHnVr3HBFZL1xuP62YY0QZ9SOCjDwn9JWn21/Ags8t0wMrGvM63bQ76kBHnVr3HBFZL1xuP62YY0QZ9SOCjDwl9S15jF21i32O3xqCHbM3Jxs0202c6j1vdjuvFfuZnZjPbr2p8BrxenDEGieeJfdND15KYCwm7Vh96k9HWj+3ctrhUXT2sOIY+JHxAHzLqrW9jDDlj8bM6ljF3yKEkRwRG8tetIhHQ+vFGaLw+02E8G4OuJ21+drX03hZre+nHrR1xrF+9wS7htdaM+qwPHaRfy3S4vX5229a89crmwHcvPa7XX5rfmneP3uZe8sHjw/6S7t5niT5leN4HG7+GE5ldtpbHiuN+zNp+3I9V6eMahuvXydqZTdTFflzH45otbujR9xJjXtq477fal3Awr4Xn9R7L6w0j9nu4LVvMqZZxvdhv+Z/ZVfo2G7/S11lYvRj0xrw/0c760EHCHmM9CVvIiAH97tLiUnVFrKxvugo9Q97sORn8rPYx5reKX8JZE4GR/HWryAjgmkedv8qjioCtG+9rNjr8hbxmzmwb80UXTwSeiTuzuSn8j/9Wa3YsxKtjrBWH9o8V4KDFKLsx3pKILWTL7hp9BcY167DZWFxmXbOwWXLJ4mc1Z2flfRZPhXsegZH8davICOC5S7y9XYtAZVHZmT+MzBfn1x3EKvfZs2OJVzp0gqMMXGDwEfFcKS0uM65ZuOYrSy5Z/Kzm28zcz+CqMM8jMJK/bhUZATx3ibe3axGoLCo784eR+eK8Dp2V+x9Y4pUOnUxcEF/zOsj4PmfJJYuf2MdVkpFTjN92s3weyZ8OnY1s7FoEqoqJ4YwQspEOqRdEQJzPP7Yq98SOWOKVDp3gPQMXGHxEPFdKiwvbxZJLFj+r+cbIKbY9MNPfkfx1q8gI4MwHXIm9axGoLCo782clV6vWEud16Kzc/8ASr3ToZOKC+JrXQcb3OUsuWfzEPq6SjJyq+t56BZyR/OnQ2cj8rkWgqpgYzgghG+mQekEExPn8Y6tyT+yIJV7p0AneM3CBwUfEc6W0uLBdLLlk8bOab4ycYtsDM/0dyV+3iowAznzAldi7FoHKorIzf1ZytWotcV6Hzsr9DyzxSodOJi6Ir3kdZHyfs+SSxU/s4yrJyKmq761XwBnJ38VDp4HqVgzEAXFAHBAHxAFxQBwQB8QBcUAcEAeMA7de3RkjgLc68Kz29uxVv+bsirMzf56V1z2/xPn8F/5d92/Vc4tX+ksnuMTABQYfEc+V0uLCdrHkksXPar4xcoptD8z0dyR/3SoyAjjzAVdi71oEKovKzvxZydWqtcR5HTor9z+wxCsdOpm4IL7mdZDxfc6SSxY/sY+rJCOnqr63XgFnJH86dDYyv2sRqComhjNCyEY6pF4QAXE+/9iq3BM7YolXOnSC9wxcYPAR8VwpLS5sF0suWfys5hsjp9j2wEx/R/LXrSIjgDMfcCX2rkWgsqjszJ+VXK1aS5zXobNy/wNLvNKhk4kL4mteBxnf5yy5ZPET+7hKMnKq6nvrFXBG8qdDZyPzuxaBqmJiOCOEbKRD6gUREOfzj63KPbEjlnilQyd4z8AFBh8Rz5XS4sJ2seSSxc9qvjFyim0PzPR3JH/dKjICOPMBV2LvWgQqi8rO/FnJ1aq1xHkdOiv3P7DEKx06mbggvuZ1kPF9zpJLFj+xj6skI6eqvrdeAWckfzp0NjK/axGoKiaGM0LIRjqkXhABcT7/2KrcEztiiVc6dIL3DFxg8BHxXCktLmwXSy5Z/KzmGyOn2PbATH9H8tetIiOAMx9wJfauRaCyqOzMn5VcrVpLnNehs3L/A0u80qGTiQvia14HGd/nLLlk8RP7uEoycqrqe+sVcEbyp0NnI/O7FoGqYmI4I4RspEPqBREQ5/OPrco9sSOWeKVDJ3jPwAUGHxHPldLiwnax5JLFz2q+MXKKbQ/M9Hckf90qMgI48wFXYu9aBCqLys78WcnVqrXEeR06K/c/sMQrHTqZuCC+5nWQ8X3OkksWP7GPqyQjp6q+t14BZyR/OnQ2Mr9rEagqJoYzQshGOqReEAFxPv/YqtwTO2KJVzp0gvcMXGDwEfFcKS0ubBdLLln8rOYbI6fY9sBMf0fy160iI4AzH3Al9q5FoLKo7MyflVytWkuc16Gzcv8DS7zSoZOJC+JrXgcZ3+csuWTxE/u4SjJyqup76xVwRvKnQ2cj87sWgapiYjgjhGykQ+oFERDn84+tyj2xI5Z4pUMneM/ABQYfEc+V0uLCdrHkksXPar4xcoptD8z0dyR/3SoyAjjzAVdi71oEKovKzvxZydWqtcR5HTor9z+wxCsdOpm4IL7mdZDxfc6SSxY/sY+rJCOnqr63XgFnJH86dDYyv2sRqComhjNCyEY6pF4QAXE+/9iq3BM7YolXOnSC9wxcYPAR8VwpLS5sF0suWfys5hsjp9j2wEx/R/LXrSIjgDMfcCX2rkWgsqjszJ+VXK1aS5zXobNy/wNLvNKhk4kL4mteBxnf5yy5ZPET+7hKMnKq6nvrFXBG8qdDZyPzuxaBqmJiOCOEbKRD6gUREOfzj63KPbEjlnilQyd4z8AFBh8Rz5XS4sJ2seSSxc9qvjFyim0PzPR3JH/dKjICOPMBV2LvWgQqi8rO/FnJ1aq1xHkdOiv3P7DEKx06mbggvuZ1kPF9zpJLFj+xj6skI6eqvrdeAWckfzp0NjK/axGoKiaGM0LIRjqkXhABcT7/2KrcEztiiVc6dIL3DFxg8BHxXCktLmwXSy5Z/KzmGyOn2PbATH9H8tetIiOAMx9wJfauRaCyqOzMn5VcrVpLnNehs3L/A0u80qGTiQvia14HGd/nLLlk8RP7uEoycqrqe+sVcEbyp0NnI/O7FoGqYmI4I4RspEPqBREQ5/OPrco9sSOWeKVDJ3jPwAUGHxHPldLiwnax5JLFejzHJAAAFLNJREFUz2q+MXKKbQ/M9Hckf90qMgI48wFXYu9aBCqLys78WcnVqrXEeR06K/c/sMQrHTqZuCC+5nWQ8X3OkksWP7GPqyQjp6q+t14BZyR/Fw+dBqpbMRAHxAFxQBwQB8QBcUAcEAfEAXFAHDAO3Hp1Z4wA3urAs9rbs1f9mrMrzs78eVZe9/wS5/Nf+Hfdv1XPLV7pL53gEgMXGHxEPFdKiwvbxZJLFj+r+cbIKbY9MNPfkfx1q8gI4MwHXIm9axGoLCo782clV6vWEud16Kzc/8ASr3ToZOKC+JrXQcb3OUsuWfzEPq6SjJyq+t56BZyR/OnQ2cj8rkWgqpgYzgghG+mQekEExPn8Y6tyT+yIJV7p0AneM3CBwUfEc6W0uLBdLLlk8bOab4ycYtsDM/0dyV+3iowAznzAldi7FoHKorIzf1ZytWotcV6Hzsr9DyzxSodOJi6Ir3kdZHyfs+SSxU/s4yrJyKmq761XwBnJnw6djczvWgSqionhjBCykQ6pF0RAnM8/tir3xI5Y4pUOneA9AxcYfEQ8V0qLC9vFkksWP6v5xsgptj0w09+R/HWryAjgzAdcib1rEagsKjvzZyVXq9YS53XorNz/wBKvdOhk4oL4mtdBxvc5Sy5Z/MQ+rpKMnKr63noFnJH86dDZyPyuRaCqmBjOCCEb6ZB6QQTE+fxjq3JP7IglXunQCd4zcIHBR8RzpbS4sF0suWTxs5pvjJxi2wMz/R3JX7eKjADOfMCV2LsWgcqisjN/VnK1ai1xXofOyv0PLPFKh04mLoiveR1kfJ+z5JLFT+zjKsnIqarvrVfAGcmfDp2NzO9aBKqKieGMELKRDqkXRECczz+2KvfEjljilQ6d4D0DFxh8RDxXSosL28WSSxY/q/nGyCm2PTDT35H8davICODMB1yJvWsRqCwqO/NnJVer1hLndeis3P/AEq906GTigvia10HG9zlLLln8xD6ukoycqvreegWckfzp0NnI/K5FoKqYGM4IIRvpkHpBBMT5/GOrck/siCVe6dAJ3jNwgcFHxHOltLiwXSy5ZPGzmm+MnGLbAzP9Hclft4qMAM58wJXYuxaByqKyM39WcrVqLXFeh87K/Q8s8UqHTiYuiK95HWR8n7PkksVP7OMqycipqu+tV8AZyZ8OnY3M71oEqoqJ4YwQspEOqRdEQJzPP7Yq98SOWOKVDp3gPQMXGHxEPFdKiwvbxZJLFj+r+cbIKbY9MNPfkfx1q8gI4MwHXIm9axGoLCo782clV6vWEud16Kzc/8ASr3ToZOKC+JrXQcb3OUsuWfzEPq6SjJyq+t56BZyR/OnQ2cj8rkWgqpgYzgghG+mQekEExPn8Y6tyT+yIJV7p0AneM3CBwUfEc6W0uLBdLLlk8bOab4ycYtsDM/0dyV+3iowAznzAldi7FoHKorIzf1ZytWotcV6Hzsr9DyzxSodOJi6Ir3kdZHyfs+SSxU/s4yrJyKmq761XwBnJnw6djczvWgSqionhjBCykQ6pF0RAnM8/tir3xI5Y4pUOneA9AxcYfEQ8V0qLC9vFkksWP6v5xsgptj0w09+R/HWryAjgzAdcib1rEagsKjvzZyVXq9YS53XorNz/wBKvdOhk4oL4mtdBxvc5Sy5Z/MQ+rpKMnKr63noFnJH86dDZyPyuRaCqmBjOCCEb6ZB6QQTE+fxjq3JP7IglXunQCd4zcIHBR8RzpbS4sF0suWTxs5pvjJxi2wMz/R3JX7eKjADOfMCV2LsWgcqisjN/VnK1ai1xXofOyv0PLPFKh04mLoiveR1kfJ+z5JLFT+zjKsnIqarvrVfAGcmfDp2NzO9aBKqKieGMELKRDqkXRECczz+2KvfEjljilQ6d4D0DFxh8RDxXSosL28WSSxY/q/nGyCm2PTDT35H8davICODMB1yJvWsRqCwqO/NnJVer1hLndeis3P/AEq906GTigvia10HG9zlLLln8xD6ukoycqvreegWckfxdPHQaqG7FQBwQB8QBcUAcEAfEAXFAHBAHxAFxwDhw69WdMQJ4qwPPam/PXvVrzq44O/PnWXnd80ucz3/h33X/Vj23eKW/dIJLDFxg8BHxXCktLmwXSy5Z/KzmGyOn2PbATH9H8tetIiOAMx9wJfauRaCyqOzMn5VcrVpLnNehs3L/A0u80qGTiQvia14HGd/nLLlk8RP7uEoycqrqe+sVcEbyp0NnI/O7FoGqYmI4I4RspEPqBREQ5/OPrco9sSOWeKVDJ3jPwAUGHxHPldLiwnax5JLFz2q+MXKKbQ/M9Hckf90qMgI48wFXYu9aBCqLys78WcnVqrXEeR06K/c/sMQrHTqZuCC+5nWQ8X3OkksWP7GPqyQjp6q+t14BZyR/OnQ2Mr9rEagqJoYzQshGOqReEAFxPv/YqtwTO2KJVzp0gvcMXGDwEfFcKS0ubBdLLln8rOYbI6fY9sBMf0fy160iI4AzH3Al9q5FoLKo7MyflVytWkuc16Gzcv8DS7zSoZOJC+JrXgcZ3+csuWTxE/u4SjJyqup76xVwRvKnQ2cj87sWgapiYjgjhGykQ+oFERDn84+tyj2xI5Z4pUMneM/ABQYfEc+V0uLCdrHkksXPar4xcoptD8z0dyR/3SoyAjjzAVdi71oEKovKzvxZydWqtcR5HTor9z+wxCsdOpm4IL7mdZDxfc6SSxY/sY+rJCOnqr63XgFnJH86dDYyv2sRqComhjNCyEY6pF4QAXE+/9iq3BM7YolXOnSC9wxcYPAR8VwpLS5sF0suWfys5hsjp9j2wEx/R/LXrSIjgDMfcCX2rkWgsqjszJ+VXK1aS5zXobNy/wNLvNKhk4kL4mteBxnf5yy5ZPET+7hKMnKq6nvrFXBG8qdDZyPzuxaBqmJiOCOEbKRD6gUREOfzj63KPbEjlnilQyd4z8AFBh8Rz5XS4sJ2seSSxc9qvjFyim0PzPR3JH/dKjICOPMBV2LvWgQqi8rO/FnJ1aq1xHkdOiv3P7DEKx06mbggvuZ1kPF9zpJLFj+xj6skI6eqvrdeAWckfzp0NjK/axGoKiaGM0LIRjqkXhABcT7/2KrcEztiiVc6dIL3DFxg8BHxXCktLmwXSy5Z/KzmGyOn2PbATH9H8tetIiOAMx9wJfauRaCyqOzMn5VcrVpLnNehs3L/A0u80qGTiQvia14HGd/nLLlk8RP7uEoycqrqe+sVcEbyp0NnI/O7FoGqYmI4I4RspEPqBREQ5/OPrco9sSOWeKVDJ3jPwAUGHxHPldLiwnax5JLFz2q+MXKKbQ/M9Hckf90qMgI48wFXYu9aBCqLys78WcnVqrXEeR06K/c/sMQrHTqZuCC+5nWQ8X3OkksWP7GPqyQjp6q+t14BZyR/OnQ2Mr9rEagqJoYzQshGOqReEAFxPv/YqtwTO2KJVzp0gvcMXGDwEfFcKS0ubBdLLln8rOYbI6fY9sBMf0fy160iI4AzH3Al9q5FoLKo7MyflVytWkuc16Gzcv8DS7zSoZOJC+JrXgcZ3+csuWTxE/u4SjJyqup76xVwRvKnQ2cj87sWgapiYjgjhGykQ+oFERDn84+tyj2xI5Z4pUMneM/ABQYfEc+V0uLCdrHkksXPar4xcoptD8z0dyR/3SoyAjjzAVdi71oEKovKzvxZydWqtcR5HTor9z+wxCsdOpm4IL7mdZDxfc6SSxY/sY+rJCOnqr63XgFnJH86dDYyv2sRqComhjNCyEY6pF4QAXE+/9iq3BM7YolXOnSC9wxcYPAR8VwpLS5sF0suWfys5hsjp9j2wEx/R/LXrSIjgDMfcCX2rkWgsqjszJ+VXK1aS5zXobNy/wNLvNKhk4kL4mteBxnf5yy5ZPET+7hKMnKq6nvrFXBG8nfx0GmguhUDcUAcEAfEAXFAHBAHxAFxQBwQB8QB48CtV3fGCOCtDjyrvT171a85u+LszJ9n5XXPL3E+/4V/1/1b9dzilf7SCS4xcIHBR8RzpbS4sF0suWTxs5pvjJxi2wMz/R3JX7eKjADOfMCV2LsWgcqisjN/VnK1ai1xXofOyv0PLPFKh04mLoiveR1kfJ+z5JLFT+zjKsnIqarvrVfAGcmfDp2NzO9aBKqKieGMELKRDqkXRECczz+2KvfEjljilQ6d4D0DFxh8RDxXSosL28WSSxY/q/nGyCm2PTDT35H8davICODMB1yJvWsRqCwqO/NnJVer1hLndeis3P/AEq906GTigvia10HG9zlLLln8xD6ukoycqvreegWckfzp0NnI/K5FoKqYGM4IIRvpkHpBBMT5/GOrck/siCVe6dAJ3jNwgcFHxHOltLiwXSy5ZPGzmm+MnGLbAzP9Hclft4qMAM58wJXYuxaByqKyM39WcrVqLXFeh87K/Q8s8UqHTiYuiK95HWR8n7PkksVP7OMqycipqu+tV8AZyZ8OnY3M71oEqoqJ4YwQspEOqRdEQJzPP7Yq98SOWOKVDp3gPQMXGHxEPFdKiwvbxZJLFj+r+cbIKbY9MNPfkfx1q8gI4MwHXIm9axGoLCo782clV6vWEud16Kzc/8ASr3ToZOKC+JrXQcb3OUsuWfzEPq6SjJyq+t56BZyR/OnQ2cj8rkWgqpgYzgghG+mQekEExPn8Y6tyT+yIJV7p0AneM3CBwUfEc6W0uLBdLLlk8bOab4ycYtsDM/0dyV+3iowAznzAldi7FoHKorIzf1ZytWotcV6Hzsr9DyzxSodOJi6Ir3kdZHyfs+SSxU/s4yrJyKmq761XwBnJnw6djczvWgSqionhjBCykQ6pF0RAnM8/tir3xI5Y4pUOneA9AxcYfEQ8V0qLC9vFkksWP6v5xsgptj0w09+R/HWryAjgzAdcib1rEagsKjvzZyVXq9YS53XorNz/wBKvdOhk4oL4mtdBxvc5Sy5Z/MQ+rpKMnKr63noFnJH86dDZyPyuRaCqmBjOCCEb6ZB6QQTE+fxjq3JP7IglXunQCd4zcIHBR8RzpbS4sF0suWTxs5pvjJxi2wMz/R3JX7eKjADOfMCV2LsWgcqisjN/VnK1ai1xXofOyv0PLPFKh04mLoiveR1kfJ+z5JLFT+zjKsnIqarvrVfAGcmfDp2NzO9aBKqKieGMELKRDqkXRECczz+2KvfEjljilQ6d4D0DFxh8RDxXSosL28WSSxY/q/nGyCm2PTDT35H8davICODMB1yJvWsRqCwqO/NnJVer1hLndeis3P/AEq906GTigvia10HG9zlLLln8xD6ukoycqvreegWckfzp0NnI/K5FoKqYGM4IIRvpkHpBBMT5/GOrck/siCVe6dAJ3jNwgcFHxHOltLiwXSy5ZPGzmm+MnGLbAzP9Hclft4qMAM58wJXYuxaByqKyM39WcrVqLXFeh87K/Q8s8UqHTiYuiK95HWR8n7PkksVP7OMqycipqu+tV8AZyZ8OnY3M71oEqoqJ4YwQspEOqRdEQJzPP7Yq98SOWOKVDp3gPQMXGHxEPFdKiwvbxZJLFj+r+cbIKbY9MNPfkfx1q8gI4MwHXIm9axGoLCo782clV6vWEud16Kzc/8ASr3ToZOKC+JrXQcb3OUsuWfzEPq6SjJyq+t56BZyR/OnQ2cj8rkWgqpgYzgghG+mQekEExPn8Y6tyT+yIJV7p0AneM3CBwUfEc6W0uLBdLLlk8bOab4ycYtsDM/0dyV+3iowAznzAldi7FoHKorIzf1ZytWotcV6Hzsr9DyzxSodOJi6Ir3kdZHyfs+SSxU/s4yrJyKmq761XwBnJ38VDp4HqVgzEAXFAHBAHxAFxQBwQB8QBcUAcEAeMA7de3RkjgLc68Kz29uxVv+bsirMzf56V1z2/xPn8F/5d92/Vc4tX+ksnuMTABQYfEc+V0uLCdrHkksXPar4xcoptD8z0dyR/3SoyAjjzAVdi71oEKovKzvxZydWqtcR5HTor9z+wxCsdOpm4IL7mdZDxfc6SSxY/sY+rJCOnqr63XgFnJH86dDYyv2sRqComhjNCyEY6pF4QAXE+/9iq3BM7YolXOnSC9wxcYPAR8VwpLS5sF0suWfys5hsjp9j2wEx/R/LXrSIjgDMfcCX2rkWgsqjszJ+VXK1aS5zXobNy/wNLvNKhk4kL4mteBxnf5yy5ZPET+7hKMnKq6nvrFXBG8qdDZyPzuxaBqmJiOCOEbKRD6gUREOfzj63KPbEjlnilQyd4z8AFBh8Rz5XS4sJ2seSSxc9qvjFyim0PzPR3JH98VWRmBIWtCCgCioAioAgoAoqAIqAIKAKKgCJQGgEdOkvDKTBFQBFQBBQBRUARUAQUAUVAEVAEFAEfAR06fTTUVgQUAUVAEVAEFAFFQBFQBBQBRUARKI2ADp2l4RSYIqAIKAKKgCKgCCgCioAioAgoAoqAj4AOnT4aaisCioAioAgoAoqAIqAIKAKKgCKgCJRGQIfO0nAKTBFQBBQBRUARUAQUAUVAEVAEFAFFwEdAh04fDbUVAUVAEVAEFAFFQBFQBBQBRUARUARKI6BDZ2k4BaYIKAKKgCKgCCgCioAioAgoAoqAIuAjoEOnj4baioAioAgoAoqAIqAIKAKKgCKgCCgCpRHQobM0nAJTBBQBRUARUAQUAUVAEVAEFAFFQBHwEdCh00dDbUVAEVAEFAFFQBFQBBQBRUARUAQUgdIIfPkP/+V/HFr3P/1X//6gWzEQB8QBcUAcEAfqOPDVV18d4q341sVXsVQsxQFxQBx4Pg50D53//N/8x4NuxUAcEAfEAXFAHKjjgB04/WV9xbcuvoqlYikOiAPiwPNxoHvo/Be/+58OuhUDcUAcEAfEAXGgjgPZoVPxrYuvYqlYigPigDjwfBzoHjr/5e/954NuxUAcEAfEAXFAHKjjQHboVHzr4qtYKpbigDggDjwfB778/n/5H4fW/a//7X896FYMxAFxQBwQB8SBOg7YoTPeim9dfBVLxVIcEAfEgefjQPfQ+bv/7r8ddCsG4oA4IA6IA+KAOCAOiAPigDggDogDoxzoHjp/7/f/+0G3YiAOiAPigDggDogD4oA4IA6IA+KAODDKgf8PcLo50cvuhpIAAAAASUVORK5CYII=" /><br /> <br /> 출고현황과 입고현황 영역을 잘 보시기 바랍니다.<br /> <br /> 입고현황 영역 =OFFSET(입고현황!$B$5,0,0,COUNTA(입고현황!$B:$B),COUNTA(입고현황!$5:$5))<br /> <br /> 출고현황 영역 =OFFSET(출고현황!$B$5,0,0,COUNTA(출고현황!$B:$B),COUNTA(출고현황!$5:$5))<br /> <br /> <br /> <br />
📄
출고현황-영역.png
삭제
파일 첨부
저장
취소
2023.11.27
1
외윤내랑
Lv.4
작성자
@김재규
님
감사합니다!! 알려주신 방법으로 사용하고 공부하겠습니다!!
감사합니다!! 알려주신 방법으로 사용하고 공부하겠습니다!!
파일 첨부
저장
취소
2023.11.27
좋아요
김재규
Lv.30
해당 파일을 올려보세요
해당 파일을 올려보세요
파일 첨부
저장
취소
2023.11.27
1
외윤내랑
Lv.4
작성자
@김재규
님
해당 파일 밑에 올려 놓았습니다. 도움 부탁드립니다 ㅠ
해당 파일 밑에 올려 놓았습니다. 도움 부탁드립니다 ㅠ
파일 첨부
저장
취소
2023.11.27
좋아요
외윤내랑
Lv.4
작성자
"업체3"으로 검색시 오류 확인 가능하십니다.
고견들 부탁드립니다. ㅠ
📄 매입매출_처리현황_2311_V6-복사본.xlsm (496 KB)
"업체3"으로 검색시 오류 확인 가능하십니다.<br /> <br /> 고견들 부탁드립니다. ㅠ
📄
매입매출_처리현황_2311_V6-복사본.xlsm
삭제
파일 첨부
저장
취소
2023.11.27
좋아요
댓글을 작성하려면
로그인
이 필요합니다.
목록
▲ TOP
게시판 목록
페이지 1 / 978
게시글 제목
날짜
조회
추천
더 이상 새 글꼴을 적용할 수 없습니다.
[1]
이도형
15시간 전
조회
89
0
답글 1
엑셀 두개의 파일 실행취소
[1]
Hazys
19시간 전
조회
84
0
답글 1
구글 시트에서 googlefinnace 함수 관련 초보 질문 드립니다
[2]
박창준
3일 전
조회
125
0
답글 2
조건에 맞는 글자 나타나게 하기
[2]
꿈꾸는집사
3일 전
조회
145
0
답글 2
감사합니다 자시 공부시작하려구요 LM. 보고서요
김지우
3일 전
조회
111
0
답글 0
도움 요청드립니다. 50대 중반에 엑셀이 너무 힘드네요
[3]
김이도
4일 전
조회
201
0
답글 3
조건부 값 불러오기 질문 드립니다.
[10]
흐린뒤맑음
4일 전
조회
216
0
답글 10
countif에서 시간값을 가져올때
[2]
나이쓰
4일 전
조회
154
0
답글 2
라이브 강의에서 만든 리본 메뉴 드롭다운 메뉴 한 번 클릭 후 다시 클릭이 안됨
suil****
4일 전
조회
113
0
답글 0
FILTER 함수를 엑셀 2016 버전으로 사용할 수 있게 함수로 변경 문의드립니다.
[2]
Miss쾌남
5일 전
조회
184
0
답글 2
엑셀 매크로 설정이 안되네요
[1]
평일에는
5일 전
조회
146
0
답글 1
코파일럿 플로팅 버튼 관련
[1]
공삼일구
6일 전
조회
148
0
답글 1
참여 그룹 수 산출
[7]
꿈꾸는집사
6일 전
조회
222
0
답글 7
챌린지 자료가 입력이 안되요ㅜㅜ
[2]
김은지
2026.05.11
조회
161
0
답글 2
[도움 절실] 도와주세요항목에 따른 배점으로 변환하는 방법
처음처럼1
2026.05.11
조회
176
0
답글 0
4만행 이상 데이터는 파워쿼리 사용할 수 없나요?
[4]
띠뛰빠빵
2026.05.09
조회
199
0
답글 4
피벗테이블 대분류 비어있음 해결하고싶어요
[2]
엘리쟈
2026.05.07
조회
233
0
답글 2
주차별 매출계획 변동내역 분석 과정에서 문의드립니다!
[2]
김평선
2026.05.06
조회
209
0
답글 2
다른시스템에 복붙할때 글꼴색이 안바뀌는 현상..
[2]
jihye****
2026.05.06
조회
224
0
답글 2
글꼴색 버튼 비활성화되었을 때 해결방법좀 찾아주세요! ><
[1]
jihye****
2026.05.06
조회
199
0
답글 1
1
2
3
...
978
다음
×
링크 삽입/편집
닫기
대상 URL을 입력하세요
URL
링크 텍스트
새 탭에서 링크 열기
또는 기존의 콘텐츠에 링크
검색
검색어가 지정되지 않았습니다. 최근 항목을 표시 중입니다.
검색하거나 위와 아래 화살키를 이용하여 항목을 선택하세요.
취소
매입은 문제가 없는데 매출에서 문제가 발생하는 중입니다.
출고현황과 입고현황 영역을 잘 보시기 바랍니다.
입고현황 영역 =OFFSET(입고현황!$B$5,0,0,COUNTA(입고현황!$B:$B),COUNTA(입고현황!$5:$5))
출고현황 영역 =OFFSET(출고현황!$B$5,0,0,COUNTA(출고현황!$B:$B),COUNTA(출고현황!$5:$5))
고견들 부탁드립니다. ㅠ