Dear All,
here is a formulae to pick up a random value.
=TEXT(RANDBETWEEN(0,9999),"0000").
I need to know how (under what creteria) this formulae pick up a next random value.
please be appreciated.
Roofi
Dear All,
here is a formulae to pick up a random value.
=TEXT(RANDBETWEEN(0,9999),"0000").
I need to know how (under what creteria) this formulae pick up a next random value.
please be appreciated.
Roofi
Abdul Rouf Roofi
The RANDBETWEEN(0,9999) will just produce the number between the given range...
Even with duplicates and with improper order of number too![]()
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks