Hi All,
I work a lot with distances in my line of work. I need to prepare a matrix of all possible combinations of from and to's.
An example I have 4 values for from and 4 for to
From To
A 1
B 2
C 3
D 4
I want to get all possible combinations. Which in this case will be 16
From To
A 1
A 2
A 3
A 4
B 1
B 2
B 3
B 4
C 1
C 2
C 3
C 4
D 1
D 2
D 3
D 4
Just to give an overview. These points are addresses in a town or state. So I need to get the distances for each from and to combination. So I have to prepare a matrix in excel. The distances are worked out in a software outside of excel. But the matrix is required in order to tell the software which combinations are required.
I am not sure if it will be a simple formula to write or a macro.
Any help appreciated.
Thank you
Bookmarks