« RANDOM DATES without DUPLICATES | SUMPRODUCT can COUNT » |
RANDOM NUMBERS without DUPLICATES
FormulasHi there,
There is a new project which is going to add to my portfolio in few days from now. And, I come across a challenge where I need to create a random numbers wherein there should not be any duplicates. Do you have any idea? Pleaes do post it in the comments. If not, step with me.
First of all, let me reveal the new project which is going to be added in a few days because finally you are the one who loves me a lot by purchasing my products, suggesting good ideas, grooming me with love and affection. Here you go:
I am starting a new website which stands next to these websites.
...
Yes, you are right. I am starting an online shopping portal in a few days from now. I will reveal further details later in this blog However, for now we will proceed to the topic.
WHY UNIQUE RANDOM NUMBERS ?
To create a gift coupons, promo codes, discount coupons etc., the RANDBETWEEN is the best and most prominent function in Excel which will do our job more easy.
FORMULA USED HERE IS:
To see how to create a unique random numbers use:
BOOM!
=RANDBETWEEN(10,100)+RAND()
the above formula can generate almost 91 unique random numbers. See if you find any duplicates. I tried in my lappy and for almost 100+ instances, I have not received even a single duplicate. So, I can suggest you to go with this formula.
That's all from my end, see you soon...
IS IT USEFUL?
Please teach me, if you have different way of doing this by using below comments section.
If you like this post, please do share it on your social networking sites just by clicking on the icons placed around the blog.
If you want to join to our wealthy community, please REGISTER here for free.
SOME IMPORTANT LINKS:
Thanks,
There are 3 comments on this post but you must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments