+ Reply to Thread
Results 1 to 3 of 3

Need to know if this is possible?? If so help please:-?

  1. #1
    Registered User
    Join Date
    07-07-2005
    Posts
    2

    Need to know if this is possible?? If so help please:-?

    I need some help with figuring a combination of formulas. Going down the first column I want to have different combinations of 2 letters from(A,B,C,D,E) these i would input, which will be coordinates, ie(A,C A,A). Next I would like to have all possible permutations for (A,B,C,D,E) listed across the top of each column, each possibility in its own cell. Next thing is to assign values to each letter A-1,B-2,C-3,D-4,E-5. So in another column the letters change order and each letter gets another value ie(E-1,D-2,C-3,B-4,A-5). Then under each permutaion having the results from the coordinates on the left, oh yeah the graph goes like this 5x5 and using a,b,c,d,e for the first row, f,g,h,i,j for the second and so forth, skipping q, when it comes up. I hope I explained this pretty clearly, and I don't know if this is even possible. I would much appreciate some help. Thanks alot.

  2. #2
    Dave O
    Guest

    Re: Need to know if this is possible?? If so help please:-?

    Do you mind posting an example of what the data looks like, and what is
    your goal? I'm not following.


  3. #3
    Registered User
    Join Date
    07-07-2005
    Posts
    2
    <<1 2 3 4 5
    1 A B C D E
    2 F G H I J
    3 K L M N O
    4 P R S T U
    5 V W X Y Z

    The above is the graph, So the spreadsheet should look something like this
    COORDIANATE
    PAIRS /(A-1,B-2,C-3,D-4,E-5)/(E-1,A-2,B-3,C-4,D-5)/ etc.


    E,A-----------------E-----------------F
    C,E-----------------X-----------------D
    A,A-----------------A-----------------G
    C,C----------------M------------------T
    A,D-----------------P-----------------W
    B,C-----------------L-----------------S
    E,A-----------------E-----------------F


    I would like it where I could input the coordianates and then get all the possible permutations and their letters from the graph out of it. Is this too big a task for excel. I hope I've explained my self better. If not I attached a better example.

+ 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