• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatic sequence provided

herofox

Active Member
hello every one
i want to ask you to make special serial by conditions
for example ,cell a2=9001 then
D2=1 & E2= A
IF COLUMN D=FROM 1 TILL 8 ,IT Should be COLUMN E=A…etc
 

Attachments

  • BOOK2.xlsx
    75.7 KB · Views: 5
Hi !​
No need a code as it can be done by easy formulas : a substraction in column D and VLOOKUP in column E on table M:O …​
Once achieve for first row, just copy down the formulas.​
 
Formula solution (helper columns in M:O is not required)

In D2, copied down :

=MOD(A2,1000)

In E2, copied down :

=SUBSTITUTE(ADDRESS(1,INT((D2-1)/7)+1,4),1,)

Regards
Bosco
 

Attachments

  • serial Number(BY).xlsx
    127.9 KB · Views: 8
Back
Top