Create a auto sequencing based on the other column value

[pratheesh1983]

I need to create a table that consists of two columns, the first being Serial No., in a sequence from 1 to 100,000. Columns. 2 is having a code value that will have a format that is based on the serial number value from column 1, i.e., if the serial number is between 1 and 1000, then the code value will be 1, and if the serial number is between 1001 and 2000, the code value will be 2, which means after each 1000, the code value will change, and this needs to be followed until the serial value is 100,000. Can you please help find a simple way to pull the value in column 2, i.e., for code, buy auto-populate the number based on the serial number?

 

[Peter_SSs]

Is this what you mean?

=LET(SN,SEQUENCE(100000),HSTACK(SN,INT((SN-1)/1000+1)))

 

[SanjayGMusafir]

In Cell A2 use formula

=SEQUENCE(100000,,1,1)

In cell B2 use formula

=ROUNDUP(A2#/1000,0)

Done

 

[pratheesh1983]

Thank you Peter and Sanjay for your help

 

[Peter_SSs]

You're welcome. Hopefully you were able to get something of use. Thanks for the follow-up.