LinkBack URL
About LinkBacks
Hello everybody
In range("E1:E20") I put this formula to get random numbers between 1 and 20
I want to get the results to be unique not to be duplicated.. Is there a way to do that?
Please Login or Register to view this content.
Hello everybody
In range("E1:E20") I put this formula to get random numbers between 1 and 20
I want to get the results to be unique not to be duplicated.. Is there a way to do that?Please Login or Register to view this content.
In a helper column type =Rand()
then in Column E, type =RANK(F1,$F$1:$F$20) and copy down
Assume column F is your helper column
Alan
Have you debugged your code?
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks a lot Mr. alansidman
Is there UDF Function that can do that task?
Please Login or Register to view this content.
Mr. Kalak you are a great man.. really fantastic wonderful
I try to begin my results in B2 but I failed .. what should I change to achieve that?
Thank you very much sir
Ok thanks I got it
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks