View Single Post
  #1   Report Post  
GC_surfer34
 
Posts: n/a
Default


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