Developing Possible Combinations Using Concatenate
Rate this:
(3/5 from 1 vote)
I really need some assistance to develop an analysis system using excel for my research. I was wondering whether anybody can assist me here.
My sets of data are normally tabulated in the following manner (either a 6 by 6 table or 4 by 4 table)
Excel Spreadsheet:
A
B
C
D
E
F
1
a
b
c
d
e
f
2
g
h
i
j
k
l
3
m
n
o
p
q
r
4
s
t
u
v
w
x
5
y
z
1
2
3
4
6
5
6
7
8
9
0
I need to tabulate the possible 6 digit combination using the 6*6 table above. The numbers cell that for the combination has to be link. I.e:- iouty6 or ahnu12 or 94xqjd.
Does any one know how to develop the above in excel sheet?
I am not an expert in VBA. So if you can show me how it is done step-by-step, I would appreciate it very much. I can also me contacted through email at [email protected]. thank you
