• 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

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

Marc L

Excel Ninja
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.​
 
Top