{"id":59588,"date":"2024-11-13T14:51:22","date_gmt":"2024-11-13T20:51:22","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=59588"},"modified":"2025-01-03T17:30:49","modified_gmt":"2025-01-03T23:30:49","slug":"funcion-coincidir","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/funcion-coincidir.html","title":{"rendered":"Funci\u00f3n COINCIDIR de Excel"},"content":{"rendered":"

Estas listo para aprender a aplicar la Funci\u00f3n COINCIDIR paso a paso ? Te gustar\u00eda conocer la sintaxis y la ventaja de utilizar esta funci\u00f3n ?<\/p>\n

Hola! Soy Roger Perez y en este articulo te voy a compartir el ejemplo de como utilizar la funcion Coincidir y aplicarlo en tus labores diarios.<\/p>\n

Estas listo para comenzar?<\/p>\n

Veamos:<\/p>\n

Sintaxis de la Funcion Coincidir<\/h1>\n

Para comenzar a utilizar la funcion Coincidir, debes de entender bien la sintaxis de esta funcion.<\/p>\n

Veamos su sintaxis:=COINCIDIR(valor_buscado;matriz_buscada;[Tipo_de_coincidencia])A continuacion los detalles de cada sintaxis:Valor buscado = Aqui debes de reflejar la celda en la cual tienes el valor o texto a buscar.Matriz buscada = Aqui vamos a escribir el rango en el cual vamos a buscar el valor o texto.Tipo de Coincidencia = Aqui vamos a escribir como queremos buscar el valor dentro del la matriz buscada, si lo quieres buscar por: Coincidencia exacta, Menor que o Mayor que.<\/p><\/blockquote>\n

\"Funcion<\/span><\/p>\n

Muy bien, ahora que conoces la sintaxis, te voy a compartir un ejemplo de como utilizar la funcion.<\/p>\n

Ejemplo de como utilizar la Funcion Coincidir<\/h2>\n

Para mostrarte el ejemplo de como utilizar la funcion coincidir e preparado un archivo para que podemos realizar la practica facilmente. A continuacion te dejo el archivo:<\/p>\n

<\/a><\/p>\n

Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p>\n

Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p>\n

Ya descargaste el archivo ? si la respuesta es un si, el siguiente paso es abrir el archivo.<\/p>\n

Dentro de este archivo, nos ubicamos en la celda G6 escribimos la palabra \u00abPepsi\u00bb, con el cual pretendemos saber cual es la ubicacion o posicion de la palabra Pepsi en la matriz.Para eso, nos ubicamos en la celda H6 y escribimos la siguiente formula:=COINCIDIR(G6;E6:E11;0) Y en seguida pulsamos enter, podras notar que el valor devuelto es el 2, lo que significa que esta en la posicion 2.\u200bAhora vamos a escribir en la Celda G6 el numero 85 y en la H6 escribimos la siguiente formula:<\/p>\n

=COINCIDIR(G6;D6:D11;0)<\/p>\n

Y en seguida pulsamos enter, podras notar que el valor devuelto es el 5, lo que significa que esta en la posicion 5.Que tal te parecio el articulo de hoy ? Tienes alguna idea de como utilizar mejor la nueva funcion coincidirx ? Dejame tu comentario al final de este arituculo.<\/p>\n

No olvides compartir este contenido con tus amigos de facebook<\/a>, para que ellos tambien puedan utilizar las ventajas de la nueva funcion coincidirx:<\/p>\n

Cualquier duda o pregunta, tan solo escribenos en el chat<\/a> o bien al correo electronico rogerperez@aplicaexcelcontable.com.Saludos,Roger Perez – Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Estas listo para aprender a aplicar la Funci\u00f3n COINCIDIR paso a paso ? Te gustar\u00eda conocer la sintaxis y la ventaja de utilizar esta funci\u00f3n ? Hola! Soy Roger Perez y en este articulo te voy a compartir el ejemplo de como utilizar la funcion Coincidir y aplicarlo en tus labores diarios. Estas listo para […]<\/p>\n","protected":false},"author":1,"featured_media":59589,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"

\n\t
<\/div>\n\t
\t

Estas listo para aprender a aplicar la Funci\u00f3n COINCIDIR paso a paso ? Te gustar\u00eda conocer la sintaxis y la ventaja de utilizar esta funci\u00f3n ?<\/p>

Hola! Soy Roger Perez y en este articulo te voy a compartir el ejemplo de como utilizar la funcion Coincidir y aplicarlo en tus labores diarios.<\/p>

Estas listo para comenzar?<\/p>

Veamos:<\/p><\/div><\/div>\n<\/div>

__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"c92f4\":{\"name\":\"Flamingo\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"1\",\"value\":{\"colors\":{\"c92f4\":{\"val\":\"rgb(212, 172, 65)\",\"hsl\":{\"h\":43,\"s\":0.63,\"l\":0.54,\"a\":1}}},\"gradients\":[]},\"original\":{\"colors\":{\"c92f4\":{\"val\":\"rgb(212, 172, 65)\",\"hsl\":{\"h\":43,\"s\":0.63,\"l\":0.54,\"a\":1}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div><\/path><\/path><\/symbol><\/path><\/path><\/symbol><\/path><\/path><\/symbol><\/svg>
<\/div><\/div>
__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"c92f4\":{\"name\":\"Flamingo\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"1\",\"value\":{\"colors\":{\"c92f4\":{\"val\":\"rgb(212, 172, 65)\",\"hsl\":{\"h\":43,\"s\":0.63,\"l\":0.54,\"a\":1}}},\"gradients\":[]},\"original\":{\"colors\":{\"c92f4\":{\"val\":\"rgb(212, 172, 65)\",\"hsl\":{\"h\":43,\"s\":0.63,\"l\":0.54,\"a\":1}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t
<\/div>\n\t
\n\t
<\/div>\n\t
\n\t\t
<\/path><\/svg><\/div>\n\t\t
\t\t\t
Tabla de Contenido<\/div> \t\t<\/div>\n\t<\/div>\n<\/div>
\n\t\t\n\n\t\t
\n\t\t\t
<\/div>\n\t\t\t
\n\t\t\t\t
1.<\/span><\/div>Sintaxis de la Funcion Coincidir<\/a><\/div>
1.1<\/span><\/div>Ejemplo de como utilizar la Funcion Coincidir<\/a><\/div><\/div>
<\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div>

Sintaxis de la Funcion Coincidir<\/h1><\/div>
\n\t
<\/div>\n\t

Para comenzar a utilizar la funcion Coincidir, debes de entender bien la sintaxis de esta funcion.<\/p>

Veamos su sintaxis:

=COINCIDIR(valor_buscado;matriz_buscada;[Tipo_de_coincidencia])

A continuacion los detalles de cada sintaxis:

Valor buscado = Aqui debes de reflejar la celda en la cual tienes el valor o texto a buscar.
Matriz buscada = Aqui vamos a escribir el rango en el cual vamos a buscar el valor o texto.
Tipo de Coincidencia = Aqui vamos a escribir como queremos buscar el valor dentro del la matriz buscada, si lo quieres buscar por: Coincidencia exacta, Menor que o Mayor que.<\/blockquote><\/div><\/div>\n<\/div>
\"Funcion<\/span><\/div>
\n\t
<\/div>\n\t
\t

Muy bien, ahora que conoces la sintaxis, te voy a compartir un ejemplo de como utilizar la funcion.<\/p><\/div><\/div>\n<\/div>

Ejemplo de como utilizar la Funcion Coincidir<\/h2><\/div>
\n\t
<\/div>\n\t
\t

Para mostrarte el ejemplo de como utilizar la funcion coincidir e preparado un archivo para que podemos realizar la practica facilmente. A continuacion te dejo el archivo:<\/p><\/div><\/div>\n<\/div>

\n\t
<\/div>\n\t
<\/path><\/svg><\/div><\/a><\/div><\/div>

Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p><\/div>

\t

Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p><\/div>

<\/path><\/svg><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/div>
\n\t
<\/div>\n\t
\t

Ya descargaste el archivo ? si la respuesta es un si, el siguiente paso es abrir el archivo.<\/p>

Dentro de este archivo, nos ubicamos en la celda G6 escribimos la palabra \"Pepsi\", con el cual pretendemos saber cual es la ubicacion o posicion de la palabra Pepsi en la matriz.

Para eso, nos ubicamos en la celda H6 y escribimos la siguiente formula:

=COINCIDIR(G6;E6:E11;0)

Y en seguida pulsamos enter, podras notar que el valor devuelto es el 2, lo que significa que esta en la posicion 2.

Ahora vamos a escribir en la Celda G6 el numero 85 y en la H6 escribimos la siguiente formula:<\/p>

=COINCIDIR(G6;D6:D11;0)<\/p>

Y en seguida pulsamos enter, podras notar que el valor devuelto es el 5, lo que significa que esta en la posicion 5.

Que tal te parecio el articulo de hoy ? Tienes alguna idea de como utilizar mejor la nueva funcion coincidirx ? Dejame tu comentario al final de este arituculo.<\/p>

No olvides compartir este contenido con tus amigos de facebook<\/a>, para que ellos tambien puedan utilizar las ventajas de la nueva funcion coincidirx:<\/p><\/div><\/div>\n<\/div>

\n
\n\t\n\t\t\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t\n <\/path>\n <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\tCompartir<\/span>\n\t\t\t\t0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t\n <\/path>\n <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\tTweet<\/span>\n\t\t\t\t0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t\n <\/path>\n <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\tPin<\/span>\n\t\t\t\t0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\n<\/div>\n<\/div><\/div>
\n\t
<\/div>\n\t
\t

Cualquier duda o pregunta, tan solo escribenos en el chat<\/a> o bien al correo electronico rogerperez@aplicaexcelcontable.com.

Saludos,

Roger Perez - Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-193268f112d\"] { --tve-font-size: 20px; --tve-color: rgb(7, 0, 0); --tve-applied---tve-color: rgb(7, 0, 0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193268f112d\"] h6 { color: var(--tve-color, rgb(7, 0, 0)); --tve-applied-color: var$(--tve-color, rgb(7, 0, 0)); --tcb-applied-color: rgb(7, 0, 0); }[data-css=\"tve-u-193268f112d\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193268f1133\"] { margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-19326913dc7\"] { --tve-toc-indent: 15px; --tcb-local-color-42606: rgb(212,172,65); --tcb-local-color-e429f: rgb(114,107,85); padding: 20px !important; --tcb-local-color-c92f4: rgb(212,172,65); margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-19326913dc9\"] { box-shadow: rgba(0, 0, 0, 0.06) 0px 0px 10px 6px; --tve-applied-box-shadow: 0px 0px 10px 6px rgba(0,0,0,0.06); border: none !important; background-color: rgb(255, 255, 255) !important; }[data-css=\"tve-u-19326913dcc\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding: 20px !important; }:not(#tve) [data-css=\"tve-u-19326913dcd\"] { background-image: linear-gradient(var(--tcb-local-color-c92f4),var(--tcb-local-color-c92f4)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-c92f4),var$(--tcb-local-color-c92f4)) !important; }[data-css=\"tve-u-19326913dc8\"] .tve_sep { background-image: linear-gradient(rgba(212, 172, 65, 0), rgba(212, 172, 65, 0)) !important; width: 1px !important; --tve-applied-background-image: linear-gradient(rgba(212,172,65,0),rgba(212,172,65,0)) !important; }[data-css=\"tve-u-19326913dca\"] .tve-toc-title-icon { color: var(--tcb-local-color-c92f4) !important; --tve-applied-color: var$(--tcb-local-color-c92f4) !important; font-size: 22px !important; width: 22px !important; height: 22px !important; }:not(#tve) [data-css=\"tve-u-19326913dca\"] p, :not(#tve) [data-css=\"tve-u-19326913dca\"] li, :not(#tve) [data-css=\"tve-u-19326913dca\"] blockquote, :not(#tve) [data-css=\"tve-u-19326913dca\"] address, :not(#tve) [data-css=\"tve-u-19326913dca\"] .tcb-plain-text, :not(#tve) [data-css=\"tve-u-19326913dca\"] label { font-size: var(--tve-font-size,20px); font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); }[data-css=\"tve-u-19326913dca\"] { --tve-font-size: 20px; --tve-font-weight: var(--g-bold-weight,bold); --tve-color: rgb(79,79,79); --tve-applied---tve-color: rgb(79,79,79); border-bottom: 1px solid var(--tcb-local-color-c92f4) !important; border-top: 1px solid var(--tcb-local-color-c92f4) !important; padding-top: 10px !important; padding-bottom: 10px !important; margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-19326913dca\"] p, :not(#tve) [data-css=\"tve-u-19326913dca\"] li, :not(#tve) [data-css=\"tve-u-19326913dca\"] blockquote, :not(#tve) [data-css=\"tve-u-19326913dca\"] address, :not(#tve) [data-css=\"tve-u-19326913dca\"] .tcb-plain-text, :not(#tve) [data-css=\"tve-u-19326913dca\"] label, :not(#tve) [data-css=\"tve-u-19326913dca\"] h1, :not(#tve) [data-css=\"tve-u-19326913dca\"] h2, :not(#tve) [data-css=\"tve-u-19326913dca\"] h3, :not(#tve) [data-css=\"tve-u-19326913dca\"] h4, :not(#tve) [data-css=\"tve-u-19326913dca\"] h5, :not(#tve) [data-css=\"tve-u-19326913dca\"] h6 { color: var(--tve-color,rgb(79,79,79)); --tve-applied-color: var$(--tve-color,rgb(79,79,79)); --tcb-applied-color: rgb(79,79,79); }[data-css=\"tve-u-19326913dca\"].tve-state-expanded { --animation-angle: -180deg; }:not(#tve) [data-css=\"tve-u-19326913dd0\"]:hover .tve-toc-disabled { font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; text-decoration: var(--tve-text-decoration,underline) !important; }:not(#tve) [data-css=\"tve-u-19326913dd0\"]:hover { --tve-font-weight: var(--g-regular-weight,normal) !important; --tve-text-decoration: underline !important; }[data-css=\"tve-u-19326913dc8\"] { margin-left: 20px !important; margin-right: 20px !important; }:not(#tve) [data-css=\"tve-u-19326913dca\"]:hover:not(.tve-state-expanded) p, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover li, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover blockquote, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover address, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover .tcb-plain-text, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover label, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover h1, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover h2, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover h3, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover h4, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover h5, :not(#tve) [data-css=\"tve-u-19326913dca\"]:hover h6 { color: var(--tve-color,var(--tcb-local-color-c92f4)) !important; --tve-applied-color: var$(--tve-color,var$(--tcb-local-color-c92f4)) !important; --tcb-applied-color: var$(--tcb-local-color-c92f4) !important; }[data-css=\"tve-u-19326913dca\"].tve-state-expanded .tve-toc-title-icon { color: var(--tcb-local-color-c92f4) !important; --tve-applied-color: var$(--tcb-local-color-c92f4) !important; }:not(#tve) [data-css=\"tve-u-19326913dca\"]:hover:not(.tve-state-expanded) .tve-toc-title-icon { color: var(--tcb-local-color-c92f4) !important; --tve-applied-color: var$(--tcb-local-color-c92f4) !important; }[data-css=\"tve-u-19326913dce\"] { text-transform: var(--tve-text-transform,none); --tve-text-transform: none; color: var(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; --tve-font-size: 16px; font-size: var(--tve-font-size,16px); letter-spacing: var(--tve-letter-spacing,1px); --tve-letter-spacing: 1px; text-align: left; --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-applied---tve-color: rgb(255,255,255); border-top: none; border-right: none; border-bottom: 1px solid rgba(255, 255, 255, 0); border-left: none; border-image: initial; --tve-applied-border: 2px solid rgba(255,255,255,0); line-height: var(--tve-line-height,1.5em); --tve-line-height: 1.5em; text-shadow: none; --tve-applied-text-shadow: none; padding-top: 6px !important; margin-top: 0px !important; padding-bottom: 5px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-19326913dce\"].tve-state-expanded { color: var(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-applied---tve-color: rgb(255,255,255); border-bottom: 1px solid rgba(255, 255, 255, 0.3); font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); --tve-font-weight: var(--g-bold-weight,bold); }:not(#tve) [data-css=\"tve-u-19326913dce\"]:hover { text-decoration: var(--tve-text-decoration,none) !important; --tve-text-decoration: none !important; color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; --tve-applied-color: var$(--tve-color,rgb(255,255,255)) !important; --tve-applied---tve-color: rgb(255,255,255) !important; border-bottom: 1px solid rgba(255, 255, 255, 0.2) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; }:not(#tve) [data-css=\"tve-u-19326913dce\"]:hover [data-css=\"tve-u-19326913dd0\"] .tve-toc-disabled { font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); }[data-css=\"tve-u-19326913dce\"]:hover [data-css=\"tve-u-19326913dd0\"] { --tve-font-weight: var(--g-bold-weight,bold); }[data-css=\"tve-u-19326913dd1\"] { --tve-font-size: 15px; font-size: var(--tve-font-size,15px); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; letter-spacing: var(--tve-letter-spacing,1px); --tve-letter-spacing: 1px; color: var(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); text-align: left; --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-applied---tve-color: rgb(255,255,255); border-bottom: 1px solid rgba(255, 255, 255, 0); line-height: var(--tve-line-height,1.5em); --tve-line-height: 1.5em; padding-top: 6px !important; margin-top: 0px !important; padding-bottom: 6px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-19326913dd1\"].tve-state-expanded { color: var(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); border-bottom: 1px solid rgba(255, 255, 255, 0.3); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-applied---tve-color: rgb(255,255,255); font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); --tve-font-weight: var(--g-bold-weight,bold); }:not(#tve) [data-css=\"tve-u-19326913dd1\"]:hover { text-decoration: var(--tve-text-decoration,none) !important; --tve-text-decoration: none !important; color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; --tve-applied-color: var$(--tve-color,rgb(255,255,255)) !important; --tve-applied---tve-color: rgb(255,255,255) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; border-top: none !important; border-right: none !important; border-bottom: 1px solid rgba(255, 255, 255, 0.2) !important; border-left: none !important; border-image: initial !important; --tve-applied-border: 2px solid rgba(255,255,255,0.15) !important; }:not(#tve) [data-css=\"tve-u-19326913dd1\"]:hover [data-css=\"tve-u-19326913dd2\"] .tve-toc-disabled { font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); }[data-css=\"tve-u-19326913dd1\"]:hover [data-css=\"tve-u-19326913dd2\"] { --tve-font-weight: var(--g-bold-weight,bold); }[data-css=\"tve-u-19326913dd3\"] { --tve-font-size: 15px; font-size: var(--tve-font-size,15px); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; color: var(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); letter-spacing: var(--tve-letter-spacing,1px); --tve-letter-spacing: 1px; --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-applied---tve-color: rgb(255,255,255); border-bottom: 1px solid rgba(255, 255, 255, 0); line-height: var(--tve-line-height,1.5em); --tve-line-height: 1.5em; border-right: none; border-left: none; border-top: none; padding-top: 5px !important; margin-top: 0px !important; padding-bottom: 6px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-19326913dd3\"]:hover { text-decoration: var(--tve-text-decoration,none) !important; --tve-text-decoration: none !important; color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; border-bottom: 1px solid rgba(255, 255, 255, 0.2) !important; --tve-applied-color: var$(--tve-color,rgb(255,255,255)) !important; --tve-applied---tve-color: rgb(255,255,255) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; border-right: none !important; border-left: none !important; border-top: none !important; }[data-css=\"tve-u-19326913dd3\"].tve-state-expanded { color: var(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-applied---tve-color: rgb(255,255,255); border-bottom: 1px solid rgba(255, 255, 255, 0.3); font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); --tve-font-weight: var(--g-bold-weight,bold); background-image: none !important; --tve-applied-background-image: none !important; }:not(#tve) [data-css=\"tve-u-19326913dd3\"]:hover [data-css=\"tve-u-19326913dd4\"] .tve-toc-disabled { font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); }[data-css=\"tve-u-19326913dd3\"]:hover [data-css=\"tve-u-19326913dd4\"] { --tve-font-weight: var(--g-bold-weight,bold); }[data-css=\"tve-u-19326913dd0\"] { padding: 0px !important; }[data-css=\"tve-u-19326913dd2\"] { padding: 0px !important; }[data-css=\"tve-u-19326913dd4\"] { padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-19326933f7c\"] { --tve-font-size: 20px; --tve-color: rgb(7, 0, 0); --tve-applied---tve-color: rgb(7, 0, 0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326933f7c\"] h6 { color: var(--tve-color, rgb(7, 0, 0)); --tve-applied-color: var$(--tve-color, rgb(7, 0, 0)); --tcb-applied-color: rgb(7, 0, 0); }[data-css=\"tve-u-19326933f7c\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19326933f81\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-193269ac703\"] { width: 245px; --tve-alignment: center; margin: 0px auto !important; float: none; border: 5px dashed rgb(205, 20, 232); --tve-applied-border: 5px dashed rgb(205, 20, 232); --tve-border-width: 5px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-193269cce12\"] { --tve-font-size: 20px; --tve-color: rgb(7, 0, 0); --tve-applied---tve-color: rgb(7, 0, 0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269cce12\"] h6 { color: var(--tve-color, rgb(7, 0, 0)); --tve-applied-color: var$(--tve-color, rgb(7, 0, 0)); --tcb-applied-color: rgb(7, 0, 0); }[data-css=\"tve-u-193269cce12\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193269cce17\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-193269f4c17\"] { --tve-font-size: 20px; --tve-color: rgb(7, 0, 0); --tve-applied---tve-color: rgb(7, 0, 0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269f4c17\"] h6 { color: var(--tve-color, rgb(7, 0, 0)); --tve-applied-color: var$(--tve-color, rgb(7, 0, 0)); --tcb-applied-color: rgb(7, 0, 0); }[data-css=\"tve-u-193269f4c17\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193269f4c1c\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 10px !important; }[data-css=\"tve-u-193269fc04e\"] { font-size: 84px; margin-left: auto; margin-right: auto; --tcb-local-color-icon: rgb(4, 228, 38); --tcb-local-color-var: rgb(4, 228, 38); --tve-icon-size: 84px; --tcb-icon-rotation-angle: -22deg; width: 84px; height: 84px; }:not(#tve) [data-css=\"tve-u-193269fc04e\"] > :first-child { color: rgb(4, 228, 38); --tve-applied-color: rgb(4, 228, 38); }[data-css=\"tve-u-193269fc04f\"] { max-width: 18.1%; }[data-css=\"tve-u-193269fc050\"] { max-width: 81.9%; }:not(#tve) [data-css=\"tve-u-193269fc051\"] { font-size: 21px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193269fc052\"] h6 { color: var(--tve-color, rgb(0, 3, 6)); --tve-applied-color: var$(--tve-color, rgb(0, 3, 6)); --tcb-applied-color: rgb(0, 3, 6); }[data-css=\"tve-u-193269fc052\"] { --tve-color: rgb(0, 3, 6); --tve-applied---tve-color: rgb(0, 3, 6); text-align: justify; }[data-css=\"tve-u-193269fc052\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-193269fc054\"] { margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-193269fc055\"] { margin-top: 0px !important; padding-top: 0px !important; padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-193269fc056\"] { --tve-border-width: 6px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; border: 6px dashed rgb(234, 194, 13) !important; --tve-applied-border: 6px dashed rgb(234, 194, 13) !important; }[data-css=\"tve-u-193269fc057\"] { font-size: 60px; --tcb-local-color-icon: rgb(227, 12, 38); --tcb-local-color-var: rgb(227, 12, 38); --tve-icon-size: 60px; float: none; z-index: 3; position: relative; --tve-alignment: center; margin: -109px auto 0px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-193269fc057\"] > :first-child { color: rgb(227, 12, 38); --tve-applied-color: rgb(227, 12, 38); }:not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-19326c92550\"] { --tve-font-size: 20px; --tve-color: rgb(7, 0, 0); --tve-applied---tve-color: rgb(7, 0, 0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19326c92550\"] h6 { color: var(--tve-color, rgb(7, 0, 0)); --tve-applied-color: var$(--tve-color, rgb(7, 0, 0)); --tcb-applied-color: rgb(7, 0, 0); }[data-css=\"tve-u-19326c92550\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19326c92554\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-19327477663\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-19327477664\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-193274804bb\"] { --tve-font-size: 20px; --tve-color: rgb(7, 0, 0); --tve-applied---tve-color: rgb(7, 0, 0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193274804bb\"] h6 { color: var(--tve-color, rgb(7, 0, 0)); --tve-applied-color: var$(--tve-color, rgb(7, 0, 0)); --tcb-applied-color: rgb(7, 0, 0); }[data-css=\"tve-u-193274804bb\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193274804c0\"] { margin-top: 0px !important; margin-bottom: 10px !important; }}@media (max-width: 1023px){[data-css=\"tve-u-19326913dc8\"] { margin-right: 15px !important; margin-left: 15px !important; }[data-css=\"tve-u-19326913dc8\"] .tve_sep { background-image: linear-gradient(rgb(212, 172, 65), rgb(212, 172, 65)) !important; width: 1px !important; --tve-applied-background-image: linear-gradient(rgb(212,172,65),rgb(212,172,65)) !important; }}@media (max-width: 767px){[data-css=\"tve-u-19326913dc7\"] { padding: 12px !important; }[data-css=\"tve-u-19326913dcc\"] { padding: 15px !important; }[data-css=\"tve-u-19326913dc8\"] { margin-right: 0px !important; margin-left: 0px !important; }[data-css=\"tve-u-19326913dc8\"] .tve_sep { background-image: linear-gradient(rgb(212, 172, 65), rgb(212, 172, 65)) !important; width: 1px !important; --tve-applied-background-image: linear-gradient(rgb(212,172,65),rgb(212,172,65)) !important; }[data-css=\"tve-u-19326913dca\"] { padding-top: 8px !important; padding-bottom: 8px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[7656],"tags":[7644,7645,7643],"class_list":["post-59588","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-funciones-excel","tag-coincidir","tag-coincidir-de-excel","tag-funcion-coincidir","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/59588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=59588"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/59588\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/59589"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=59588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=59588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=59588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}