Hello,
I am trying to figure out how to increment letters in my workbook.
I need to do the following
200, 200A, 200B, etc thru the letter Z, then after the number reaches 200Z, it will increment to 201, 201A, 201B, etc thru Z, and then repeat. I need the numbr to go vertically, not horizontally. I have tried to build custom lists, etc, and cant get it to work. Any ideas?
I dont necessarily need it to increment the numbers, but if I could get it to increment the A-Z that would be ideal.
Thanks
Last edited by nov0798; 10-10-2013 at 06:38 PM.
something like this
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
See the attached file.
Dutch A2Dutch B2
Please Login or Register to view this content.Dutch C2Please Login or Register to view this content.Please Login or Register to view this content.
oeldere, just out of curiosity, would you mind translating that into english please?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins
In that case you need to open the attachment.
Then you will see the english formula.
That's why I (always) try to post an attachment.
(i have a dutch version, so my formula are in dutch).
I post the dutch formula, so i can see what I answered (it is easier to respond, if i see it in the answer).
OK I didnt open the file, was just looking for a quick translation, no problem
@FDibbins
No problem.
Glad to answer your question.
Try pasting the following formula in cell A2 then copy down.
=200+COUNTIF($A$1:A1,"*Z")&RIGHT(SUBSTITUTE(ADDRESS(1,ROWS($1:1),4),"1",""),1)
Try this (don't know it will run on Excel 2003 or not):
Increment Letters nov0798.xlsPlease Login or Register to view this content.
Last edited by SDCh; 10-10-2013 at 11:59 PM.
Click (*) if you received helpful response.
Regards,
David
welcome to the forum, nov0798. try:
=200+INT((ROW(1:1)-1)/27)&IF(MOD((ROW(1:1)-1),27),CHAR(MOD((ROW(1:1)-1),27)+64),"")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Great. Thanks to all the replies! I REALLY do appreciate it.
if A1 = 200
write this formula at A2
=IF(ISNUMBER(A1),A1&"A",IF(RIGHT(A1)="Z",LEFT(A1,LEN(A1)-1)+1,SUBSTITUTE(A1,RIGHT(A1),CHAR(CODE(RIGHT(A1))+1))))
and drug (copy) down see the result
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks