+ Reply to Thread
Results 1 to 5 of 5

Find the Path! (File Attached!)

  1. #1
    Registered User
    Join Date
    11-16-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Talking Find the Path! (File Attached!)

    Here are my cells

    Coloumn
    A B C D

    A 1 2 10
    B 1 3 21
    C 1 4 29
    D 2 3 9
    E 2 5 27
    F 3 6 28
    G 3 5 14
    H 4 6 17
    I 5 6 12

    Coloumn A: Section Name.
    Coloumn B: Start Node
    Coloumn C: End Node
    Coloumn D: Value

    Each section has specific value(Coloumn D)
    It always start at node #1, end at node #6.
    There will be many possible paths(rutes).
    1 - 2 - 3 - 5 - 6(ADGI) : 45
    1 - 2 - 5 - 6(AEI) : 49
    1 - 4 - 6(CH) : 46
    1 - 3 - 5 - 6(BGI) : 47
    etc..
    What i want the resule is "The path with Maximum value".
    So, in the specific cell(C10) need to show "AEI"
    in the another specific cell(D10) need to show "49"


    It is very challenging for me.. and If I can, I do not want to use VBA since it is hard to troubleshoot(my co-worker don't know how to use VBA) However, if it is the only way, then VBA would be fine!

    One more thing,
    If and only if possible, I want to show every possible paths..

    I need your help!
    I appreciate it in advance!


    Thanks!
    Attached Files Attached Files
    Last edited by kidongee; 11-23-2011 at 06:31 PM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Find the Path!

    You might have to elaborate. Please post a workbook.

  3. #3
    Registered User
    Join Date
    11-16-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Find the Path!

    That is the all data of workbook I have

    Coloumn
    A B C D

    A 1 2 10
    B 1 3 21
    C 1 4 29
    D 2 3 9
    E 2 5 27
    F 3 6 28
    G 3 5 14
    H 4 6 17
    I 5 6 12

    Coloumn A: Section Name
    Coloumn B: Start Node
    Coloumn C: End Node
    Coloumn D: Value

    Thank you!

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Find the Path!

    Yes, but that is not a workbook. Either you mock something up, or I do. And it isn't going to me!

  5. #5
    Registered User
    Join Date
    11-16-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Find the Path! (File Attached)

    I attached the file! Thank you StephenR!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1