#1   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default auto populate

Hello,

I suggest to take my UDF UniqRandInt() from www.sulprobil.com.

If your names are listed in A1:A16, for example, then select cells B1:B25
and enter
=INDEX(A1:A16,UniqRandInt(16,2))
as array-formula (with CTRL+SHIFT+ENTER).

Please keep in mind that my function returns an error value if the length of
your list is less than 16 * 2 as B. R. Ramachandran already pointed out.

HTH,
Bernd


Reply
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
Auto populate fields Mark Excel Discussion (Misc queries) 1 September 15th 05 08:45 PM
Function for Auto Populate [email protected] Excel Worksheet Functions 3 July 28th 05 03:26 AM
Auto populate cells based on 2 cells division. Chance224 Excel Discussion (Misc queries) 0 April 4th 05 09:35 PM
Auto Populate a cell Bellsouth Excel Discussion (Misc queries) 3 March 30th 05 02:27 PM
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 7th 04 11:53 PM


All times are GMT +1. The time now is 07:55 AM.

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"