2 Formas de Extrair Valores Únicos de uma Planilha no Excel

Edson Cavalcante 06/03/2017 Atualizado em: 07/05/2019 Comente! Aprender Excel Avançado, Aprender Excel Intermediário

Videoaula: 2 Formas de Extrair Valores Únicos no Excel

Artigo anterior Como remover todos os hiperlinks indesejáveis no Excel

Próximo artigo PROCV com 2 condições (PROCV DUPLO)

@font-face{font-style:normal;font-family:Roboto Slab;src:url("https://cdn-bfphi.nitrocdn.com/oxCBHFRFkcvpJEmipAFwaFQsIEAfVuFz/assets/static/source/rev-6033bd0/198.71.233.45/dc9.efb.myftpupload.com/wp-content/themes/epico/fonts/roboto-slab/subset/roboto-slab-300-subset.woff2") format("woff2"),url("https://cdn-bfphi.nitrocdn.com/oxCBHFRFkcvpJEmipAFwaFQsIEAfVuFz/assets/static/source/rev-6033bd0/198.71.233.45/dc9.efb.myftpupload.com/wp-content/themes/epico/fonts/roboto-slab/subset/roboto-slab-300-subset.woff") format("woff");font-weight:300;font-display:swap;}@font-face{font-style:normal;font-family:Roboto Slab;src:url("https://cdn-bfphi.nitrocdn.com/oxCBHFRFkcvpJEmipAFwaFQsIEAfVuFz/assets/static/source/rev-6033bd0/198.71.233.45/dc9.efb.myftpupload.com/wp-content/themes/epico/fonts/roboto-slab/subset/roboto-slab-regular-subset.woff2") format("woff2"),url("https://cdn-bfphi.nitrocdn.com/oxCBHFRFkcvpJEmipAFwaFQsIEAfVuFz/assets/static/source/rev-6033bd0/198.71.233.45/dc9.efb.myftpupload.com/wp-content/themes/epico/fonts/roboto-slab/subset/roboto-slab-regular-subset.woff") format("woff");font-weight:regular;font-display:swap;}.epc-ovr[class*=epc-s] #footer ::-moz-selection,.epc-ovr[class*=epc-s] #sidebar-promo ::-moz-selection,.epc-ovr[class*=epc-s] section[class*="pop-id"] ::-moz-selection,.epc-ovr[class*=epc-s] .capture-wrap ::-moz-selection{background:#1fac61;}.epc-ovr[class*=epc-s] #footer ::selection,.epc-ovr[class*=epc-s] #sidebar-promo ::selection,.epc-ovr[class*=epc-s] section[class*="pop-id"] ::selection,.epc-ovr[class*=epc-s] .capture-wrap ::selection{background:#1fac61;}.epc-ovr[class*="epc-"] .sidebar section[class*="epico_pages"] a,.epc-ovr[class*="epc-"] .sidebar section[class*="epico_links"] a,.epc-ovr .wp-calendar>caption,.epc-ovr input[type="submit"],.epc-ovr #header #nav input.search-submit[type="submit"],.epc-ovr #header .not-found input.search-submit[type="submit"],.epc-ovr.zen #sidebar-after-content .sb.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .uberaviso,.epc-ovr[class*="epc-"] .fw.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .sb.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .sc.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] #sidebar-after-content .sb.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .epico_author a[class*=button],.epc-ovr[class*="epc-"] input[type="submit"],.epc-ovr[class*="epc-"] .fw.capture-wrap a.uf-submit,.epc-ovr[class*="epc-"] .sb.capture-wrap a.uf-submit,.epc-ovr[class*="epc-"] .not-found input.search-submit[type="submit"]{background:#1fac61;}.epc-ovr .pagination .page-numbers.current{background:#1fac61 !important;}.epc-ovr #footer .widget_tag_cloud a:hover,.epc-ovr .loop-meta,.epc-ovr #menu-primary-items .sub-menu li a:hover,.epc-ovr .epc-button-border-primary,.epc-ovr #footer .search-field:hover,.epc-ovr #footer .search-field:focus,.epc-ovr .author-profile,.epc-ovr.page-template-landing{border-left:5px solid #1fac61 !important;}.epc-ovr #credits,.epc-ovr[class*="epc-"] .sidebar .epico_pop,.epc-ovr[class*="epc-"] .sidebar .epico_pop > div,.epc-ovr[class*="epc-"] #footer .epico_social a:hover,.epc-ovr .comment-reply-link{border-color:#1fac61 !important;}.epc-ovr .epc-button-border-primary,.epc-ovr #footer .epico_social a:hover,.epc-ovr #sidebar-top li:hover::before,.epc-ovr #menu-primary .sub-menu li a:hover::before,.epc-ovr #footer li:hover::before,.epc-ovr #menu-primary li.menu-item-has-children a:hover::before,.epc-ovr #menu-secondary li a:hover::before,.epc-ovr #search-toggle:hover::after,.epc-ovr .search-close .search-text,.epc-ovr #search-toggle::before,.epc-ovr #search-toggle:hover .search-text,.epc-ovr .search-text:hover,.epc-ovr #zen:hover i,.epc-ovr #zen.zen-active i,.epc-ovr #zen.zen-active:hover i,.epc-ovr.zen #footer a{color:rgba(31,172,97,.8) !important;}.epc-ovr .sidebar .epico_pop h3[class*="title"]::before,.epc-ovr .sidebar section[class*="epico_pages"] h3[class*="title"]::before{color:rgba(31,172,97,.8);}.epc-ovr[class*="epc-"] .fw.capture-wrap .uf-arrow svg polygon,.epc-ovr[class*="epc-"] .sb.capture-wrap .uf-arrow svg polygon,.epc-ovr[class*="epc-"] #sidebar-after-content .sb.capture-wrap .uf-arrow svg polygon,.epc-ovr.zen #sidebar-after-content .sb.capture-wrap .uf-arrow svg polygon{fill:#1fac61;}@media only screen and (max-width:680px){.epc-ovr #menu-primary>ul>li a:hover::before,.epc-ovr #menu-primary li a:hover::before,.epc-ovr #nav-toggle:hover .nav-text,.epc-ovr .nav-active #nav-toggle .nav-text{color:rgba(31,172,97,.8) !important;}.epc-ovr #menu-primary-items>li a:hover{border-left:5px solid rgba(31,172,97,.8) !important;}.epc-ovr .nav-active #nav-toggle span::before,.epc-ovr .nav-active #nav-toggle span::after,.epc-ovr #nav-toggle:hover .screen-reader-text,.epc-ovr #nav-toggle:hover .screen-reader-text::after,.epc-ovr #nav-toggle:hover .screen-reader-text::before{background:#1fac61 !important;}}@media only screen and (min-width:680px){.epc-ovr #header .menu-items > li > a{color:#1fac61;}}[class*="epc-"] #menu-secondary li a.menu-item:hover::before,.epc-ovr #page .sidebar .epico_pop h3[class*="title"]::before,.epc-ovr #page .sidebar section[class*="epico_pages"] h3[class*="title"]::before,.epc-ovr #page a:not(.elementor-button):not(.wp-block-button__link):not(.uf-submit):not(.uf-link):not(.uf-page):not(.uf-social):not(.wp-block-file__button):not(.post-page-numbers):not(.comments-link-byline):not(.category-link):not(.wp-block-social-link-anchor):not(.menu-item):not(.credit-link):not(.page-numbers),.epc-ovr.plural .format-default .entry-author,.epc-ovr #breadcrumbs a,.epc-ovr #branding a,.epc-ovr #header .menu-items > li > a:hover,.epc-ovr #footer .widget_tag_cloud a:hover::before,.epc-ovr #zen.zen-active:hover i,.epc-ovr.page-template-landing #footer a,.epc-ovr .uf-wrap .uf a:not(.uf-submit){color:#1fac61 !important;}.epc-ovr #page #main-container .pagination a.page-numbers,.epc-ovr[class*="epc-"].plural .format-default .entry-author,.epc-ovr[class*=epc-s] #page #main-container .epico_author a[class*=button]{color:#fff !important;}.epc-ovr[class*=epc-s] #footer ::-moz-selection,.epc-ovr[class*=epc-s] #sidebar-promo ::-moz-selection,.epc-ovr[class*=epc-s] section[class*="pop-id"] ::-moz-selection,.epc-ovr[class*=epc-s] .capture-wrap ::-moz-selection,.epc-ovr #footer ::selection,.epc-ovr #sidebar-promo ::selection,.epc-ovr section[class*="pop-id"] ::selection,.epc-ovr .capture-wrap ::selection,.epc-ovr .epico_social a,.epc-ovr[class*=epc-s] .epico_author a[class*=button]{color:#fff;}.epc-ovr.epc-1 .uf_epicoepico_pop a,.epc-ovr.epc-2 .uf_epicoepico_pop a,.epc-ovr.epc-3 .uf_epicoepico_pop a{color:#aebbc2;}.epc-ovr #page a:not(.epico-pop_link):not(.elementor-button):not(.wp-block-button__link):not(.uf-submit):not(.uf-link):not(.uf-page):not(.uf-social):not(.wp-block-file__button):not(.post-page-numbers):not(.comments-link-byline):not(.category-link):not(.epico-pop-link):hover,.epc-ovr .comment-reply-link,.epc-ovr.page-template-landing #footer a:hover,.epc-ovr #breadcrumbs a:hover{color:#344146;}.epc-ovr .comment-reply-link:hover{border-color:#344146 !important;}.epc-ovr input[type="submit"]:hover,.epc-ovr #nav input.search-submit[type="submit"]:hover,.epc-ovr .not-found input.search-submit[type="submit"]:hover,.epc-ovr #nav input.search-submit[type="submit"]:active,.epc-ovr .not-found input.search-submit[type="submit"]:active,.epc-ovr[class*=epc-s].zen #sidebar-after-content .sb.capture-wrap .uf-submit:hover,.epc-ovr .pagination .page-numbers.current:active,.epc-ovr .pagination .page-numbers.current:hover{background:rgba(31,172,97,.6) !important;}.epc-ovr[class*=epc-s] .fw.capture-wrap .uf-submit:hover,.epc-ovr[class*=epc-s] .sb.capture-wrap .uf-submit:hover,.epc-ovr .sc.capture-wrap .uf-submit:hover,.epc-ovr #sidebar-after-content .sb.capture-wrap .uf-submit:hover,.epc-ovr[class*=epc-s] .epico_author a[class*=button]:hover,.epc-ovr[class*="epc-"] .sidebar section[class*="epico_pages"] a:hover,.epc-ovr[class*="epc-"] .sidebar section[class*="epico_links"] a:hover{background:rgba(31,172,97,.6);}.epc-ovr #page .content a.elementor-button,.epc-ovr #main-container .content a.elementor-button:hover{color:#fff;}.wordpress[class*="epc-"] #sidebar-subsidiary{background-color:#f4f4f4;color:rgba(0,0,0,.5);border-bottom:0px;}[class*="epc-"] #sidebar-subsidiary .epico_social a{background:rgba(0,0,0,.2);box-shadow:0 0 0 10px #f4f4f4;}[class*="epc-"] #sidebar-subsidiary .epico_social a:hover{box-shadow:0 0 0 10px rgba(0,0,0,.2);}.page-template-tpl-helper-pb[class*="epc-"],.page-template-tpl-helper-pb-alt[class*="epc-"],.page-template-tpl-helper-min-pb[class*="epc-"],.page-template-landing[class*="epc-"]{background-color:#fff !important;}.page-template-landing[class*="epc-"] #page,.page-template-tpl-helper-min-pb[class*="epc-"] #page{border-top:none !important;}[class*="epc-s"].plural .loop-meta{background:#42b267;}[class*="epc-s"].plural .loop-meta h1,[class*="epc-s"].plural .loop-meta p,[class*="epc-s"].plural #page .loop-meta li::before{color:rgba(255,255,255,.9);background:#42b267;}[class*="epc-s"].plural #page .loop-meta a{color:rgba(255,255,255,.6) !important;}.epc-syst,.epc-syst label,.epc-syst textarea,.epc-syst input:not([type=submit]):not([type=radio]):not([type=checkbox]):not([type=file]),.epc-syst select[multiple=multiple],.epc-syst.epc-button,.epc-syst input[type="submit"],.epc-syst a.uf-button,button.uf-button,.epc-syst .not-found input.search-submit[type="submit"],.epc-syst #nav input.search-submit[type="submit"],.epc-syst #comments .comment-reply-link,.epc-syst #comments .comment-reply-login,.epc-syst .epico_author a[class*=button],.epc-syst.wordpress div.uberaviso a[class*="button"],.epc-syst.wordpress .mejs-controls a:focus>.mejs-offscreen,.epc-syst .format-quote p:first-child::before,.epc-syst .format-quote p:first-child::after,.epc-syst .epico-related-posts h4.related-post-title,.epc-syst .placeholder,.epc-syst .editor-tag,.epc-syst .uf-title-inner,.epc-syst .wp-block-calendar table{font-family:ui-sans-serif,-apple-system,Segoe UI,system-ui,Roboto,Helvetica Neue,Arial,Noto Sans,Liberation Sans,sans-serif,Apple Color Emoji,Segoe UI Emoji,Segoe UI Symbol,Noto Color Emoji,Twemoji Mozilla;}.epc-syst li.fa,.epc-syst li.fa::before,.epc-syst .fa,.epc-syst textarea.fa,.epc-syst input:not([type=submit]):not([type=radio]):not([type=checkbox]):not([type=file]).fa,.epc-syst .not-found input.search-submit[type="submit"],.epc-syst #search-wrap input.fa[type="search"],.epc-syst #nav input.search-submit[type="submit"],.epc-syst #respond #submit,.epc-syst .capture-wrap form input[class*="uf-"]{font-family:FontAwesome,ui-sans-serif,-apple-system,Segoe UI,system-ui,Roboto,Helvetica Neue,Arial,Noto Sans,Liberation Sans,sans-serif,Apple Color Emoji,Segoe UI Emoji,Segoe UI Symbol,Noto Color Emoji,Twemoji Mozilla !important;}@media screen and (max-width:420px){.social-likes__counter{display:none;}.sticky-active .social-total-shares{right:0;}.sticky-active #social-bar-sticky #social-close{right:5px;}}.ytSubscribe-inner h3{padding:0px;float:left;color:#000;margin:9px 5px 0px 0px;line-height:20px;font-size:18px;}body.custom-background{background-color:#f4f4f4;}.dark_theme{padding:8px;background:#555;}

Videoaula: 2 Formas de Extrair Valores Únicos no Excel

Artigos relacionados