![]() ![]() ![]() The solution is based on the ability of defining by you the desired length and char/number pattern just by specifying an alphanumeric string which results in a desired random combination.I managed to fit the solution inside one formula (no lookup tables).I tried to develop on your idea and after tinkering for the last few evenings I came up with some solution that works pretty well, I think. I must say I’ve been very much inspired for some time by your ideas and contribution to the community, so firstly I want to thank you Daniel, many of your posts were a huge help. One column represents the numbers from 1-99, the other one has the numbers 65-90, repeated until all rows are filled. What we can do is creating a helper table with two column. This is more of a challenge, since with our trick we can always only randomize between 0-9, 01-99, 001-999 … but for the character formula und need to go for 65-90. The formula Right() returns just a piece of it, beginning from the right.Īll together it should give you a random number between 001 and 999. ![]() With the parameter “false” the number will not update everytime you make a change in the doc. This part can be solves with a simple =right(random(false),3) While I was able to randomize a 1-letter-3-numbers solution, I was not able to get 3-letters-3-numbers, here is how and why: Hey is currently no RANDBETWEEN function, I also requested the need to the dev team, maybe we get something like that soon.īut there is a RANDOM() function, that gives you a random float number and you can workaround a lot of stuff with it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |