Using an excel table i am creating a list of customers. Id like to give each customer an id. This is a simple as 1 ,2 etc upto n, with n being the last new entered customer in the list.
Now i have 2 additional requirements. This id should be automatically populated and also when i sort the table the id should remain with the customer. So i can sort from id 1 through n giving the sequence in wich it was entered, but sorting by lastname will give me that plus the id's remain with said lastname.