**Does anybody now how I can create a random sequence of number combinations from these most frequent used numbers?**Now, I know that the list will be huge given all of the possible random combinations possible. So, I need to narrow them down to 15 and I need them to be random and non repetitive. Like, I can draw 6 twice in the five numbers I am allowed to draw. I can get 6-11-25-33-45 or 6-25-33-35-45, etc. but not 6-6-33-35-45.

I tried doing so by generating random drawings but they are not sequences of combinations. They are random numbers from the highest picked numbers. For instance, I get, 34-5-16-49-1. I first filled in the numbers that are most drawn on table C; assigne them absolute random values on A and give the absolute values on B using this formula: =RANK($A2,$A$2:$A$22)+COUNTIF(B$1:B1,B1)-1.

**Does anybody have a better way to generate random sequence of combinations, rather than random combinations?**