Creating sequential id's in excel table

%3CLINGO-SUB%20id%3D%22lingo-sub-2260779%22%20slang%3D%22en-US%22%3ECreating%20sequential%20id's%20in%20excel%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2260779%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EUsing%20an%20excel%20table%20i%20am%20creating%20a%20list%20of%20customers.%20Id%20like%20to%20give%20each%20customer%20an%20id.%20This%20is%20a%20simple%20as%201%20%2C2%20etc%20upto%20n%2C%20with%20n%20being%20the%20last%20new%20entered%20customer%20in%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20i%20have%202%20additional%20requirements.%20This%20id%20should%20be%20automatically%20populated%20and%20also%20when%20i%20sort%20the%20table%20the%20id%20should%20remain%20with%20the%20customer.%20So%20i%20can%20sort%20from%20id%201%20through%20n%20giving%20the%20sequence%20in%20wich%20it%20was%20entered%2C%20but%20sorting%20by%20lastname%20will%20give%20me%20that%20plus%20the%20id's%20remain%20with%20said%20lastname.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2260779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

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.

 

Thanks

0 Replies