in

Código auto incrementable en Tabla de Excel (ID AUTOMÁTICO) #shorts #excel #tablasdinámicas

How can we create a code or an ID that is incremented but automatically in an Excel table. For example, here in products I am going to put Miguel Vela, he pressed enter and on the left I want you to notice that the code has just appeared automatically

. We can do it in the following way, the first thing we have to do is transform our Data Range to table format. So we are going to select all our data. We go to the insert tab. We go to table and activate this option that says the table has

Headers. We accept and what we are going to do is the following we are going to put the same thing we call the row function we open parentheses we close parentheses we press enter and what we are going

To have is the row number according to the cell where we are going to be placed After that we will we are going to subtract from the header that we have at the top but we are going to put the first row

We open parentheses we select the header we close parentheses we press enter and this way every time we add new products we will have the number

Articulo Recomendado
Curso de VBA para Excel: 10 Ejercicios Condicional If con Operadores And y Or

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

¿Las emociones complejas nos dan alguna ventaja evolutiva?

Con este corrido tumbado (a lo Junior H y peso pluma) nunca se te olvidará la tabla del 9 #powermath