LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default

Hello,

I suggest:

1. Take my function UniqRandInt() from www.sulprobil.com
2. Put at least 35 different characters of your choice into A1:A35 (because
35*351200). More won't hurt. Leave rest of column A empty.
3. Enter into B1:
=COUNTA(A:A)
4. Select the 1200 cells C1:C1200 and enter as array formula (CTRL + SHIFT +
ENTER):
=uniqrandint(B1*B1)
5. Enter into D1:
=INDEX(A:A,1+INT(C1/B$1))&INDEX(A:A,1+MOD(C1,B$1))
and copy down to D1200

HTH,
Bernd


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Random alpha generator bj Excel Worksheet Functions 3 April 27th 05 11:02 PM
How do I find random number in list of random alpha? (Position is. jlahealth-partners Excel Discussion (Misc queries) 0 February 8th 05 05:31 PM
Random number generator Philippe L. Balmanno Excel Worksheet Functions 4 December 17th 04 07:42 AM
Random # Generator vamosj Excel Worksheet Functions 0 November 8th 04 07:14 PM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"