excel

<style>/*<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

</head><body>*/</style>

엑셀 , excel

엑셀 최신 함수들 XLOOKUP TEXTSPLIT UNIQUE SORT FILTER VSTACK HSTACK

XLOOKUP (엑스룩업) VLOOKUP 이나 HLOOKUP 의 강력한 업그레이드 버전이에요! 찾을 값의 좌우 어디든 탐색이 가능하고, 찾지 못했을 때의 값을 직접 지정할 수도 있어서 훨씬 유연하게 사용할 수 있답니다. 👍 TEXTSPLIT (...

Go~~~ 2025/12/26

excel , office

LibreOffice 리브레오피스 오픈소스 무료 오피스 프로그램

https://ko.libreoffice.org/ 여러가지 사무용 프로그램을 모아놓은 고급 오피스 프로그램 모음

Go~~~ 2025/11/05

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/1350801215-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY70ldbh_IvFp0L_O5s7CFf9FrFawQ:1767769994836';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d3342237142306043724','//www.lineline.net/search/label/excel','3342237142306043724');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '3342237142306043724', 'title': 'LineLine.net', 'url': 'https://www.lineline.net/search/label/excel', 'canonicalUrl': 'https://www.lineline.net/search/label/excel', 'homepageUrl': 'https://www.lineline.net/', 'searchUrl': 'https://www.lineline.net/search', 'canonicalHomepageUrl': 'https://www.lineline.net/', 'blogspotFaviconUrl': 'https://www.lineline.net/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'ko', 'localeUnderscoreDelimited': 'ko', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22LineLine.net - Atom\x22 href\x3d\x22https://www.lineline.net/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22LineLine.net - RSS\x22 href\x3d\x22https://www.lineline.net/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22LineLine.net - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/3342237142306043724/posts/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/617ee3b89bd337b4', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': '\uacf5\uc720 \ub9c1\ud06c \ub9cc\ub4e4\uae30', 'key': 'link', 'shareMessage': '\uacf5\uc720 \ub9c1\ud06c \ub9cc\ub4e4\uae30', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Facebook\uc5d0 \uacf5\uc720', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'X\uc5d0 \uacf5\uc720', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Pinterest\uc5d0 \uacf5\uc720', 'target': 'pinterest'}, {'name': '\uc774\uba54\uc77c', 'key': 'email', 'shareMessage': '\uc774\uba54\uc77c', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27ko\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'index', 'searchLabel': 'excel', 'pageName': 'excel', 'pageTitle': 'LineLine.net: excel'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': '\uc218\uc815', 'linkCopiedToClipboard': '\ub9c1\ud06c\ub97c \ud074\ub9bd\ubcf4\ub4dc\uc5d0 \ubcf5\uc0ac\ud588\uc2b5\ub2c8\ub2e4.', 'ok': '\ud655\uc778', 'postLink': '\uae00 \ub9c1\ud06c'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': '\uc0ac\uc6a9\uc790 \uc9c0\uc815', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'LineLine.net', 'description': '\uc4f8\ubaa8\uc788\ub294 \ub044\uc801\uc784.', 'url': 'https://www.lineline.net/search/label/excel', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': 'excel', 'resultsMessage': '\ub77c\ubca8\uc774 excel\uc778 \uac8c\uc2dc\ubb3c \ud45c\uc2dc', 'resultsMessageHtml': '\ub77c\ubca8\uc774 \x3cspan class\x3d\x27search-label\x27\x3eexcel\x3c/span\x3e\uc778 \uac8c\uc2dc\ubb3c \ud45c\uc2dc'}}}, {'name': 'widgets', 'data': [{'title': 'Navbar', 'type': 'Navbar', 'sectionId': 'upload-image', 'id': 'Navbar1'}, {'title': 'LineLine.net(\ud5e4\ub354)', 'type': 'Header', 'sectionId': 'upload-image', 'id': 'Header1'}, {'title': 'Formulir Kontak', 'type': 'ContactForm', 'sectionId': 'upload-image', 'id': 'ContactForm1'}, {'title': '', 'type': 'HTML', 'sectionId': 'upload-image', 'id': 'HTML91'}, {'title': 'Cloud Labels', 'type': 'Label', 'sectionId': 'upload-image', 'id': 'Label1'}, {'title': 'List Labels', 'type': 'Label', 'sectionId': 'upload-image', 'id': 'Label2'}, {'title': 'Discussion', 'type': 'HTML', 'sectionId': 'upload-image', 'id': 'HTML4'}, {'title': '', 'type': 'HTML', 'sectionId': 'upload-image', 'id': 'HTML1'}, {'title': 'Most Viewed', 'type': 'PopularPosts', 'sectionId': 'upload-image', 'id': 'PopularPosts2', 'posts': [{'title': '\ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 Blog \uc0ac\uc774\ud2b8\ub97c \ucd94\ucc9c...', 'id': '4792053983878118038'}, {'title': 'ResizePixel\ub294 \ubcc4\ub3c4 \uc124\uce58 \uc5c6\uc774 \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \uac04\ud3b8\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc628\ub77c\uc778 \uc774\ubbf8\uc9c0 \ud3b8\uc9d1 \ub3c4\uad6c\uc785\ub2c8\ub2e4.', 'id': '2731523163043470899'}, {'title': '\ubcd1\uc624\ub144\uc740 \x27\ubd88(\u706b)\uc758 \ub9d0\ud574\x27 \ub85c \ud574\uc11d\ub429\ub2c8\ub2e4. \ubd89\uc740\ub9d0. 2026\ub144', 'id': '8292291886479551008'}, {'title': 'AdGuard DNS\ub294 \uad11\uace0, \ud2b8\ub798\ud0b9, \uc545\uc131 \uc0ac\uc774\ud2b8\ub97c \ucc28\ub2e8\ud558\ub294 \ubb34\ub8cc DNS \uc11c\ube44\uc2a4', 'id': '5544421358919701221'}, {'title': '\ud734\uc9c0\ud1b5 \ube44\uc6b4 \ud6c4 \uc601\uad6c \uc0ad\uc81c\ub41c \ud30c\uc77c \ubcf5\uad6c \ubc29\ubc95 https://kr.imyfone.com/data-recovery/', 'id': '7213453588456607137'}]}, {'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': '\ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '1508403056357470325', 'title': '\uc5d1\uc140 \ucd5c\uc2e0 \ud568\uc218\ub4e4 XLOOKUP TEXTSPLIT UNIQUE SORT FILTER VSTACK HSTACK', 'showInlineAds': false}, {'id': '3722549622454180133', 'title': 'LibreOffice \ub9ac\ube0c\ub808\uc624\ud53c\uc2a4 \uc624\ud508\uc18c\uc2a4 \ubb34\ub8cc \uc624\ud53c\uc2a4 \ud504\ub85c\uadf8\ub7a8', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': 'yyyy/MM/dd'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'share', 'label': ''}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': 'Tags:'}]}], 'allBylineItems': [{'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': 'yyyy/MM/dd'}, {'name': 'share', 'label': ''}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': 'Tags:'}]}, {'title': '\ud398\uc774\uc9c0', 'type': 'LinkList', 'sectionId': 'sidebar-static', 'id': 'LinkList1'}, {'title': 'Tag', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label10'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts10', 'posts': [{'title': 'Quick Memory Test OK for Windows. \ucef4\ud4e8\ud130 RAM \uc624\ub958 \ud14c\uc2a4\ud2b8 \ud504\ub85c\uadf8\ub7a8.', 'id': 2966048360651565230}, {'title': '\uad6d\ub0b4 \uc8fc\uc694 \ud1b5\uc2e0\uc0ac(KT, SK\ube0c\ub85c\ub4dc\ubc34\ub4dc(SK Broadband), LG U+)\uc758 \uae30\ubcf8 DNS \uc11c\ubc84 \uc8fc\uc18c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.', 'id': 2755566981476750403}, {'title': 'ResizePixel\ub294 \ubcc4\ub3c4 \uc124\uce58 \uc5c6\uc774 \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \uac04\ud3b8\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc628\ub77c\uc778 \uc774\ubbf8\uc9c0 \ud3b8\uc9d1 \ub3c4\uad6c\uc785\ub2c8\ub2e4.', 'id': 2731523163043470899}, {'title': 'arp -a \ub77c\uc6b0\ud130 \uc811\uc18d IP \uc8fc\uc18c\uc640 MAC\uc744 \ud655\uc778 \ud560\uc218 \uc788\ub2e4.', 'id': 4530896007676440005}, {'title': '\ubcd1\uc624\ub144\uc740 \x27\ubd88(\u706b)\uc758 \ub9d0\ud574\x27 \ub85c \ud574\uc11d\ub429\ub2c8\ub2e4. \ubd89\uc740\ub9d0. 2026\ub144', 'id': 8292291886479551008}]}, {'title': 'Link', 'type': 'LinkList', 'sectionId': 'sidebar-static', 'id': 'LinkList7'}, {'title': '', 'type': 'BloggerButton', 'sectionId': 'sidebar-static', 'id': 'BloggerButton1'}, {'title': 'LineLine.net', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Q\x26amp;A', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList14'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML24'}]}]);
_WidgetManager._RegisterWidget('_NavbarView', new _WidgetInfo('Navbar1', 'upload-image', document.getElementById('Navbar1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'upload-image', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm1', 'upload-image', document.getElementById('ContactForm1'), {'contactFormMessageSendingMsg': '\uc804\uc1a1 \uc911...', 'contactFormMessageSentMsg': '\uba54\uc77c\uc774 \uc804\uc1a1\ub418\uc5c8\uc2b5\ub2c8\ub2e4.', 'contactFormMessageNotSentMsg': '\uba54\uc77c\uc744 \uc804\uc1a1\ud558\uc9c0 \ubabb\ud588\uc2b5\ub2c8\ub2e4. \uc7a0\uc2dc \ud6c4 \ub2e4\uc2dc \uc2dc\ub3c4\ud574 \uc8fc\uc138\uc694.', 'contactFormInvalidEmailMsg': '\uc62c\ubc14\ub978 \uc774\uba54\uc77c \uc8fc\uc18c\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.', 'contactFormEmptyMessageMsg': '\uba54\uc2dc\uc9c0 \uc785\ub825\ub780\uc740 \ubc18\ub4dc\uc2dc \uc785\ub825\ud574\uc57c \ud569\ub2c8\ub2e4.', 'title': 'Formulir Kontak', 'blogId': '3342237142306043724', 'contactFormNameMsg': '\uc774\ub984', 'contactFormEmailMsg': '\uc774\uba54\uc77c', 'contactFormMessageMsg': '\uba54\uc2dc\uc9c0', 'contactFormSendMsg': '\ubcf4\ub0b4\uae30', 'contactFormToken': 'AOuZoY77k4yhTU0rA4p44yCvDcPRFlqT5A:1767769994836', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML91', 'upload-image', document.getElementById('HTML91'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'upload-image', document.getElementById('Label1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label2', 'upload-image', document.getElementById('Label2'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML4', 'upload-image', document.getElementById('HTML4'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'upload-image', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts2', 'upload-image', document.getElementById('PopularPosts2'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'navMessage': '\ub808\uc774\ube14\uc774 \x3cb\x3eexcel\x3c/b\x3e\uc778 \uac8c\uc2dc\ubb3c\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4. \x3ca href\x3d\x22https://www.lineline.net/\x22\x3e\ubaa8\ub4e0 \uac8c\uc2dc\ubb3c \ud45c\uc2dc\x3c/a\x3e', 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2962814487-lbx__ko.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/828616780-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList1', 'sidebar-static', document.getElementById('LinkList1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label10', 'sidebar-static', document.getElementById('Label10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-static', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList7', 'sidebar-static', document.getElementById('LinkList7'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BloggerButtonView', new _WidgetInfo('BloggerButton1', 'sidebar-static', document.getElementById('BloggerButton1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList13', 'footer-widget', document.getElementById('LinkList13'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList14', 'footer-widget', document.getElementById('LinkList14'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>

엑셀 최신 함수들 XLOOKUP TEXTSPLIT UNIQUE SORT FILTER VSTACK HSTACK

LibreOffice 리브레오피스 오픈소스 무료 오피스 프로그램

페이지

Tag

Popular Posts

Quick Memory Test OK for Windows. 컴퓨터 RAM 오류 테스트 프로그램.

국내 주요 통신사(KT, SK브로드밴드(SK Broadband), LG U+)의 기본 DNS 서버 주소는 다음과 같습니다.

ResizePixel는 별도 설치 없이 브라우저에서 간편하게 사용할 수 있는 온라인 이미지 편집 도구입니다.

arp -a 라우터 접속 IP 주소와 MAC을 확인 할수 있다.

병오년은 '불(火)의 말해' 로 해석됩니다. 붉은말. 2026년

Link