Hi-
I would like a random # generator, but only use each number once. The below does not work. Any ideas?
Please Login or Register to view this content.
Hi-
I would like a random # generator, but only use each number once. The below does not work. Any ideas?
Please Login or Register to view this content.
Sadly, that's not a native Excel Function.
You could create a random Table on a second sheet
in Col A of sheet 2 from A1:A370 = RAND()
In Col B from B1:B370 just sequential numbers 1 to 370
In Sheet 1
=INDEX(Sheet2!$B$1:$B$370,MATCH(LARGE(Sheet2!$A$1:$A$370,ROWS($A$1:$A1)),Sheet2!$A$1:$A$370,0))
copied down.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks