Results 1 to 4 of 4

Thread: Random Numbers

  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    2
    Rep Power
    0

    Random Numbers

    Below is a list of doors that Have a interlock function. Two doors cannot be open at the same time. Below is a small Section of doors That cannot be open at the same time. I have other lists of doors, that are smaller and larger than the list here. Is there some kind of VBA Code or function I can use so no two doors can be opened at the same time.

    Thank you For your time
    Don

    Section 400 Q R
    400
    401
    404
    410
    420
    430
    440
    450
    460
    470
    480
    490

  2. #2
    Member
    Join Date
    Jun 2013
    Posts
    93
    Rep Power
    12
    it's not clear for me

  3. #3
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    As patel indicated, the question is not clear, in other words, doesn't make sense. Can you please rephrase in a more easy-to-understand manner?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  4. #4
    Junior Member
    Join Date
    Jul 2013
    Posts
    2
    Rep Power
    0
    Below is a list of door numbers 827,828,G23 ect. All doors are in the same location. No two doors are allowed to be open at the same time. I need find all different combination that the list of doors numbers can possibly come together. This is just a small list.
    Please help

    Work Furlow
    827 828
    827 829
    827 G23
    828 827
    828 829
    828 G23
    829 827
    829 828
    829 G23
    G23 827
    G23 828
    G23 829
    Attached Files Attached Files

Similar Threads

  1. Replies: 2
    Last Post: 07-18-2013, 03:34 AM
  2. Get Random List :
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 06-06-2013, 07:53 PM
  3. Unique Random Number In Ascending Order
    By marreco in forum Excel Help
    Replies: 8
    Last Post: 11-04-2012, 04:15 PM
  4. Create Random Number Generator VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 12-01-2011, 10:51 AM
  5. Generate random numbers in Excel
    By Mahesh in forum Excel Help
    Replies: 3
    Last Post: 10-06-2011, 11:24 AM

Posting Permissions

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