A
B
C
D
E
10
20
30
40
50
60
70
80
90
Need a code write above sequence. with a validation point after which the Numering of integers starts following alphabets sequence
A
B
C
D
E
10
20
30
40
50
60
70
80
90
Need a code write above sequence. with a validation point after which the Numering of integers starts following alphabets sequence
I'd feed them into an array variable, either dynamically or manually.
Then use of Mod can be used to invoke then in a roll.
I put your variables from A1:A14.
Then I used the following code:
This printed a repeating sequence of the first 50 outputs in column D.Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
And manually with a static reference:
Please Login or Register to view this content.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi thanks for the help... also is there a way i can validate the numbering and code for following data
A 231
B 12e
C qwe
D r3
10 Login
20 qwe
30 asd
40 qwe
as soon as "login" word is present it should start numbering sequence and end till it finds blank cell in adjacent column
Looks good to me. You'll need to have the sequence listed for it to reference.
See Attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks