G
GC_surfer34
I need some help with figuring a combination of formulas. Going down th
first column I want to have different combinations of 2 letter
from(A,B,C,D,E) these i would input, which will be coordinates, ie(A,
A,A). Next I would like to have all possible permutations fo
(A,B,C,D,E) listed across the top of each column, each possibility i
its own cell. Next thing is to assign values to each lette
A-1,B-2,C-3,D-4,E-5. So in another column the letters change order an
each letter gets another value ie(E-1,D-2,C-3,B-4,A-5). Then under eac
permutaion having the results from the coordinates on the left, oh yea
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.
hope I explained this pretty clearly, and I don't know if this is eve
possible. I would much appreciate some help. Thanks alot
first column I want to have different combinations of 2 letter
from(A,B,C,D,E) these i would input, which will be coordinates, ie(A,
A,A). Next I would like to have all possible permutations fo
(A,B,C,D,E) listed across the top of each column, each possibility i
its own cell. Next thing is to assign values to each lette
A-1,B-2,C-3,D-4,E-5. So in another column the letters change order an
each letter gets another value ie(E-1,D-2,C-3,B-4,A-5). Then under eac
permutaion having the results from the coordinates on the left, oh yea
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.
hope I explained this pretty clearly, and I don't know if this is eve
possible. I would much appreciate some help. Thanks alot