Thank's for fast reply and sorry for my english language, couse it's my 2nd language (i'm indonesian)
@Luke M : My requirement is like what prasaddn explain.
@prasaddn : thanks' a lot. That what i'm looking for. But how if we add a new rules that there's no repeat number in 4, 3 or 2 digit...
I need help to create an excell formulas to produce a random number (consist of 4 number, 3 number, and 2 number) from 5 number given. Please help me.
Thank's