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.


--
GC_surfer34
------------------------------------------------------------------------
GC_surfer34's Profile: http://www.excelforum.com/member.php...o&userid=25017
View this thread: http://www.excelforum.com/showthread...hreadid=385466

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

<<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.


--
GC_surfer34
------------------------------------------------------------------------
GC_surfer34's Profile: http://www.excelforum.com/member.php...o&userid=25017
View this thread: http://www.excelforum.com/showthread...hreadid=385466