Do you mean that you want to create random number if so:
=rand() Give you a random number with
decimal places
=INT(RAND()*100) Give you random number without deimal
places
=randbetween(1,100000) Gives u a random number between 1,100000
or whatever u chose
A tad more detail as to the layout of your data might help
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.