Creating alphanumeric serial numbers

Give this

A2="2018/Apr/LO-"&TEXT(ROWS(A$2:A2),"000")

Copy down

Oh thank you Shukla, lemme try first ya!

Hi Shukla,

Tqvm...
More, how can i used/ or add on the 'if' and 'isblank' formula so that when i tab down to key in the next meeting, the serial no will only then poped up?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks Shukla.
Here...


I hope the attachment is there.

What is your expected result can you please explain why you are adding 101 what is the reason ?

Hi Shukla...
Walan here. Im sorry if you are not ok with this.

I hope this could explained...
I couldnt find the formula at first so i was just follow which ever formula i found. But i need a formula for an alphanumeric serial number. So there goes your helps. But then i found that it will be good too if i can use the if and isblank formula rather than dragging down it from the first column.
But the formula i found is for short numbers only.

Can you please put expected result, your explanation doesn't clear many thing as i asked earlier how you suppose to add 101 ??? You can put expected result and what is your though for the result.

I have done some modification. It is permissible, then refer attach file.
column "A" is = Date
column "B" is = Day
column "C" is = month (In Alfa)
column "D" is = year
column "E" is formula with :

Formula:

Please Login or Register  to view this content.

copy down.

Hi Shukla,

I actually just try and error by putting 101 because i don't know how. But i have already get it solve on weekend, it suppose to combined the formula u give with the IF and no need Isblank +1, "000")).
...

=IF(C7=0, " ","2018/Apr/LO-"&TEXT(ROWS(A$6:A6)+1, "000")) .... which start from the second row


Tqvm for helping!

Thats ok, if you solved you query

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.