in

Como usar la función ENCOL – ENFILA en Excel

You’re going to love this new Excel function and it’s going to simplify your life. Please tell me if you already knew it or not. Look what we’re going to do. I’m going to put the same thing. I’m going to call

The encol function. I’m going to open parentheses and I’m going to select. the range that I want in this case all this data I close parentheses I press enter and look that with a function now I have it in a single row but as you can see we have values ​​that are repeated

So that they do not repeat So we are going to play and first we are going to put the function unique I open parentheses and at the end I close parentheses I press enter and now I have values ​​that are

Not repeated, what we are going to do now is put equal we can also call the function in a row I open parentheses I select the range I close parentheses I press enter and I want you to notice that now I have all the data but in a single column

Articulo Recomendado
Control de GASTOS, INGRESOS y EGRESOS en Excel (Plantilla Contable) 📒

What do you think?

Written by d2jma

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

GIPHY App Key not set. Please check settings

💰Top 5 mejores especialidades MÉDICAS PAGADAS

Prepárate para la ETAPA REGIONAL LIMATEJ PRIMARIA 2024| Problema 2 LIMATEJ PRIMARIA REGIONAL (2023)