{"id":12762,"date":"2023-01-25T13:54:42","date_gmt":"2023-01-25T13:54:42","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=12762"},"modified":"2023-01-27T12:33:17","modified_gmt":"2023-01-27T12:33:17","slug":"comparar-dos-columnas-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/","title":{"rendered":"COMPARAR DOS COLUMNAS EN EXCEL"},"content":{"rendered":"<p style=\"text-align: center;\"><strong>El d\u00eda de hoy veremos como podemos comparar dos columnas en Excel para encontrar elementos coincidentes o hacer la comparaci\u00f3n para encontrar las diferencias.<\/strong><\/p>\n<h6 style=\"text-align: center;\">COMPARAR COLUMNAS CON FILAS QUE TIENEN LOS MISMOS DATOS<\/h6>\n<h6 style=\"text-align: left;\">A. FUNCION IGUAL<\/h6>\n<p>Esta es la comparaci\u00f3n m\u00e1s b\u00e1sica que podemos realizar para ver la coincidencia exacta de filas entre dos columnas. Se compara fila por fila para identificar aquellas que tienen el mismo valor y las que no.<\/p><div id=\"excel-2610043446\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>Para ello utilizamos una f\u00f3rmula muy sencilla para hacer la comparaci\u00f3n del valor de las columnas, en nuestro ejemplo las columnas B y C.<\/p>\n<p>La formula es:\u00a0 <strong>=B1=C1<\/strong><\/p>\n<p>Con esta f\u00f3prmula obtendremos el valor <em><strong>VERDADERO<\/strong> <\/em>para las celdas que sean exactamente iguales y el valor <em><strong>FALSO<\/strong> <\/em>cuando sean diferentes.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12764 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/verdadero-falso.png\" alt=\"COMPARAR DOS COLUMNAS EN EXCEL\" width=\"512\" height=\"467\" \/><\/p>\n<hr \/>\n<h6 style=\"text-align: left;\">B. RESALTAR CON FORMATO CONDICIONAL<\/h6>\n<p>Podemos usar la f\u00f3rmula anterior para crear una regla de<em> formato condicional<\/em> que resalte las filas que sean id\u00e9nticas.<\/p>\n<p><strong>1.<\/strong> Seleccionamos las columnas con los datos.<\/p>\n<p><strong>2.<\/strong> Vamos a la pesta\u00f1a <em><strong>Inicio<\/strong> <\/em>y dentro del grupo <em><strong>Estilos<\/strong><\/em>, pulsamos el bot\u00f3n del comando <em><strong>Formato condicional<\/strong><\/em> y elegimos la opci\u00f3n <em><strong>Nueva regla<\/strong><\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12765\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/nueva-regla.png\" alt=\"\" width=\"1054\" height=\"594\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/nueva-regla.png 1054w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/nueva-regla-1000x564.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/nueva-regla-768x433.png 768w\" sizes=\"auto, (max-width: 1054px) 100vw, 1054px\" \/><\/p>\n<p><strong>3.<\/strong> Se abrir\u00e1 el cuadro de di\u00e1logo <em><strong>Nueva regla de formato<\/strong><\/em> y debemos elegir la opci\u00f3n <em><strong>Utilice una f\u00f3rmula que determine las celdas para aplicar formato.<\/strong><\/em><\/p>\n<p><span style=\"font-size: 16px;\"><strong>4.<\/strong> En el cuadro de f\u00f3rmula debemos ingresar lo siguiente, agregando el s\u00edmbolo de moneda ($) para fijar las columnas: =$B1=$C1 <\/span><\/p>\n<p><strong>5.<\/strong> Finalmente hacemos clic en el bot\u00f3n <em><strong>Formato<\/strong><\/em> para elegir el formato que ser\u00e1 aplicado a las celdas que cumplan con la condici\u00f3n indicada en la f\u00f3rmula.<\/p>\n<p><span style=\"font-size: 16px;\"><strong>6.<\/strong> Hacemos clic en el bot\u00f3n <em><strong>Aceptar<\/strong><\/em> y se aplicar\u00e1 el formato a los datos de la hoja.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12766\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/nueva-regla-de-formato.png\" alt=\"\" width=\"507\" height=\"369\" \/><\/p>\n<p>El formato condicional resalta en verde las filas que tienen datos id\u00e9nticos mientras que podemos observar las diferencias en aquellas celdas que NO tienen un color de relleno.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12767\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/celdas-iguales.png\" alt=\"\" width=\"346\" height=\"468\" \/><\/p>\n<p>En este ejemplo las dos columnas de Excel tienen los datos en las mismas filas, pero habr\u00e1 ocasiones en las que tendremos que comparar columnas con datos desordenados.<\/p>\n<hr \/>\n<h6 style=\"text-align: center;\">COMPARAR COLUMNAS CON FILAS QUE TIENEN DATOS DESORDENADOS<\/h6>\n<h6 style=\"text-align: left;\">A. RESALTAR COINCIDENCIAS<\/h6>\n<p>Cuando tenemos dos columnas con datos desordenados y queremos verificar si los datos son coincidentes podemos usar el comando <em><strong>Valores duplicados<\/strong><\/em> del <em><strong>Formato condicional<\/strong><\/em>.<\/p>\n<p><strong>1.<\/strong> Seleccionamos las columnas de datos.<\/p>\n<p><strong>2<\/strong>. En la pesta\u00f1a <em><strong>Inicio<\/strong><\/em>, dentro del grupo <em><strong>Estilos<\/strong><\/em>, hacemos clic en el bot\u00f3n <em><strong>Formato condicional<\/strong><\/em> y dentro de <em><strong>Resa\u00f1tar reglas de celdas<\/strong><\/em> debemos elegir la opci\u00f3n <em><strong>Duplicar v<\/strong><\/em><em><strong>alores <\/strong><\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12769\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/duplicar-valores.png\" alt=\"\" width=\"470\" height=\"429\" \/><\/p>\n<p><em><strong>3.<\/strong> <\/em>En el cuadro de di\u00e1logo seleccionamos <em><strong>Duplicar<\/strong><\/em> y podemos elegir el estilo de nuestra preferencia.<\/p>\n<p><strong>4.<\/strong> Pulsamos en bot\u00f3n <em><strong>Aceptar<\/strong><\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12770 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/coincidir-duplicados.png\" alt=\"COMPARAR DOS COLUMNAS EN EXCEL\" width=\"715\" height=\"441\" \/><\/p>\n<p>Aquellos valores que se encuentran en ambas columnas estar\u00e1n resaltados de un color diferente. Por el contrario, los valores que solo est\u00e1n en una de las columnas estar\u00e1n sin color de relleno.<\/p>\n<hr \/>\n<h6 style=\"text-align: left;\">B. RESALTAR DIFERENCIAS<\/h6>\n<p>Si lo que queremos es resaltar aquellos valores que NO se encuentran en las dos columnas, podemos seguir los mismos pasos de la secci\u00f3n antyerior\u00a0 pero en el cuadro de di\u00e1logo en lugar de elegir <b><i>Duplicar,<\/i><\/b>\u00a0elegimos la opci\u00f3n <em><strong>\u00danicos<\/strong><\/em>.<\/p>\n<p>De igual manera elegimos un color de relleno y al pulsar el bot\u00f3n <em><strong>Aceptar<\/strong><\/em> tendremos resaltados los valores que solo aparecen en una de las columnas, es decir, las diferencias entre ambas columnas.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12773\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/unicos.png\" alt=\"\" width=\"735\" height=\"441\" \/><\/p>\n<p>Los valores que no tienen un color de relleno son los que se encuentran en ambas listas.<\/p>\n<hr \/>\n<p>Las t\u00e9cnicas mostradas no son las \u00fanicas que existen, pero son las m\u00e1s simples de ejecutar.\u00a0Luego, podemos encontrar variantes y t\u00e9cnicas m\u00e1s avanzadas que pueden surgir con la implementaci\u00f3n de otras herramientas que nos ofrece Excel.<\/p>\n<hr \/>\n<p>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\"><strong>Facebook<\/strong><\/a> <\/span>e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><strong>Instagram<\/strong><\/a><\/span>.<\/p>\n<p>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\"><strong>Curso de Excel Online<\/strong><\/a><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>El d\u00eda de hoy veremos &#8230; <a title=\"COMPARAR DOS COLUMNAS EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/\" aria-label=\"Leer m\u00e1s sobre COMPARAR DOS COLUMNAS EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":12778,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[454,328,346],"tags":[496,542,478],"class_list":["post-12762","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-el-entorno-de-excel","category-excel","category-excel-basico","tag-columnas","tag-comparar-columnas","tag-curso-de-excel","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>COMPARAR DOS COLUMNAS EN EXCEL - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"Podemos comparar dos columnas en Excel para encontrar los elementos coincidentes o para encontrar las diferencias.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"COMPARAR DOS COLUMNAS EN EXCEL - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"Podemos comparar dos columnas en Excel para encontrar los elementos coincidentes o para encontrar las diferencias.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-25T13:54:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-27T12:33:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"COMPARAR DOS COLUMNAS EN EXCEL\",\"datePublished\":\"2023-01-25T13:54:42+00:00\",\"dateModified\":\"2023-01-27T12:33:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/\"},\"wordCount\":654,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png\",\"keywords\":[\"columnas\",\"comparar columnas\",\"curso de excel\"],\"articleSection\":[\"El Entorno de Excel\",\"Excel\",\"Excel B\u00e1sico\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/\",\"name\":\"COMPARAR DOS COLUMNAS EN EXCEL - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png\",\"datePublished\":\"2023-01-25T13:54:42+00:00\",\"dateModified\":\"2023-01-27T12:33:17+00:00\",\"description\":\"Podemos comparar dos columnas en Excel para encontrar los elementos coincidentes o para encontrar las diferencias.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"COMPARAR DOS COLUMNAS EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"COMPARAR DOS COLUMNAS EN EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"COMPARAR DOS COLUMNAS EN EXCEL - EXCELFULL.COM","description":"Podemos comparar dos columnas en Excel para encontrar los elementos coincidentes o para encontrar las diferencias.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"COMPARAR DOS COLUMNAS EN EXCEL - EXCELFULL.COM","og_description":"Podemos comparar dos columnas en Excel para encontrar los elementos coincidentes o para encontrar las diferencias.","og_url":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-01-25T13:54:42+00:00","article_modified_time":"2023-01-27T12:33:17+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"COMPARAR DOS COLUMNAS EN EXCEL","datePublished":"2023-01-25T13:54:42+00:00","dateModified":"2023-01-27T12:33:17+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/"},"wordCount":654,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png","keywords":["columnas","comparar columnas","curso de excel"],"articleSection":["El Entorno de Excel","Excel","Excel B\u00e1sico"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/","url":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/","name":"COMPARAR DOS COLUMNAS EN EXCEL - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png","datePublished":"2023-01-25T13:54:42+00:00","dateModified":"2023-01-27T12:33:17+00:00","description":"Podemos comparar dos columnas en Excel para encontrar los elementos coincidentes o para encontrar las diferencias.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/01\/COMPARAR-DOS-COLUMNAS-EN-EXCEL.png","width":1280,"height":720,"caption":"COMPARAR DOS COLUMNAS EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/comparar-dos-columnas-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"COMPARAR DOS COLUMNAS EN EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=12762"}],"version-history":[{"count":7,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12762\/revisions"}],"predecessor-version":[{"id":12779,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12762\/revisions\/12779"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/12778"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=12762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=12762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=12762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}