Consulting

Results 1 to 4 of 4

Thread: Solved: Generate a random List of names from table

  1. 01-18-2011, 08:14 AM #1
    klutz
    klutz is offline
    VBAX Contributor
    Joined
    Jun 2009
    Posts
    110
    Location

    Solved: Generate a random List of names from table

    Hi

    Happy New Year everyone.

    I was wondering if I could get some guidance here.

    I have a table in excel that has names and country. From that one table i want to generate 5 smaller tables/list of the names but they cannot repeat.

    Can this be done?

    Klutz---out!!!!
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 01-18-2011, 12:29 PM #2
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    See attachment.
    Make your 6 tables by direct ref to the cells
    Add a column D containing =RAND().
    F9 to recalculate.
    Sort columns BCD on column D.
    Fix resultant tables by copy paste|values (in situ or elsewhere).
    Sort table again by column C to restore original order.

    http://www.box.net/shared/47qe403xgi
    Attached Files Attached Files
    Last edited by p45cal; 01-18-2011 at 12:39 PM.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
  3. 01-18-2011, 12:29 PM #3
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    deleted
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
  4. 01-18-2011, 12:47 PM #4
    klutz
    klutz is offline
    VBAX Contributor
    Joined
    Jun 2009
    Posts
    110
    Location
    Absoulutely grateful for your valuable help. I've opened the attachment and it does what is requested.

    Saludos y Gracias.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules