LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 577
Default Help with randomly displaying values from a list.

I have a list of 144 names. In a separate column, I want to break that list
up into groups of 4. Obviously, I know how to do that. But how do you
randomly select those names without duplicates?
For instance:
Names in Cells N7:N150.
Starting in cell C7 through C150, I want to randomly list those names.

Any help would be appreciated.
 
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
Displaying a list of values MFK Excel Discussion (Misc queries) 2 September 26th 08 08:56 PM
Can I randomly select values from an array with removal? bvc Excel Discussion (Misc queries) 2 February 17th 08 10:49 PM
Hi--how do I scramble a list randomly? lmcshelp Excel Worksheet Functions 1 November 1st 06 06:34 AM
Randomly Generated List / Macro carl Excel Worksheet Functions 3 April 9th 06 01:14 AM
How to randomly select from a list with condition kathyxyz Excel Worksheet Functions 5 July 27th 05 04:19 PM


All times are GMT +1. The time now is 02:24 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"