Hi, I don't know if this is even possible, but I'll try to make this as clear as I can:
In our lab, our sample numbers are in this format: yymmddPT##, where PT stands for plant (in this particular example), and the ## is the number of that sample for that day. We always have a PT01 and a PT02, at least. So the numbers from today would be 201117PT01 and 201117PT02. I want to know if there is a formula that can automatically populate these numbers based on the date entered? See attached image for what I'm looking at.
Thanks for any help in advance!!
Bookmarks