Random & Sequential Number Generators

[aws1008]

Is it possible to format in the Random number generator? I need to create a spread sheet that adds both formatted sequential numbers and formatted random numbers, and am having trouble getting started. Any and all help is appreciated!

[JBeaucaire]

Give us some examples of these formatted sequential numbers and formatted random numbers that you need to create?
Any logic you have in mind? Some people say "random" and they don't actually mean "completely random".

[aws1008]

I am trying to create a marketing piece. They will be business-sized cards that need to be unique to each of our locations.The sequential numbers will be formatted with a 2 letter location code and then just counting. On each card we will also need to generate a random access code, so it must be completely unique and be formatted in a specific way to be excepted by the POS. (5 digits always ending in zero).

[martindwilson]

well there are only 10000 numbers So just list them all stick rand() down the next column then fill down copy past back special values then you can lookup small() 1 2 3 4 and so on to get a random 5 digit code as for location codes just use countif

[aws1008]

Stumbled onto it myself.....=RANDBETWEEN(1000,9990)*ROUND(10,1)....seems to work

[martindwilson]

It wont be guaranted unique

[aws1008]

Hopefully for our limited uses it will be unique enough! Thanks for all your help!

[JBeaucaire]

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