Random single letter/digit grid

rtrnow61

New Member
Joined
Jan 1, 2019
Messages
22
Hi,

Based on Mr. Excel's YouTube video showing how to create a random non-repeating letter grid I was wondering if anyone could help me create a random single letter or number grid for 26 letters of the alphabet by the number 0-9

Example: say A-Z are the columns and 0-9 are the rows and then I can generate a random letter or number (I would like the random generation to include both random letters A-Z and numbers 0-9) and non-repeating if possible.

I am an Excel novice and have a very specific use for this to create a secret number code corresponding to pricing. The non-repeat is not required but random is.

Thank you very much for any and all assistance.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Can you give an example of what you want to do?
 
Upvote 0
Can you give an example of what you want to do?

a b c d e f g h i j k l m n o p q r s t u v w x y z (columns)

0 (rows)
1
2
3 inside this grid would be randomly generated single letters and numbers, a-z and 0-9
4
5
6
7
8
9
 
Upvote 0
Should look more like this, if I am representing correctly as it would be in a spreadsheet

a b c d e f g h i j k l m n o p q r s t u v w x y z (columns)


0 (rows)
1
2
3 inside this grid would be randomly generated single letters and numbers, a-z and 0-9
4
5
6
7
8
9
 
Upvote 0
So for example, you want a result like this?

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]
A​
[/td][td="bgcolor:#C0C0C0"]
B​
[/td][td="bgcolor:#C0C0C0"]
C​
[/td][td="bgcolor:#C0C0C0"]
D​
[/td][td="bgcolor:#C0C0C0"]
E​
[/td][td="bgcolor:#C0C0C0"]
F​
[/td][td="bgcolor:#C0C0C0"]
G​
[/td][td="bgcolor:#C0C0C0"]
H​
[/td][td="bgcolor:#C0C0C0"]
I​
[/td][td="bgcolor:#C0C0C0"]
J​
[/td][td="bgcolor:#C0C0C0"]
K​
[/td][td="bgcolor:#C0C0C0"]
L​
[/td][td="bgcolor:#C0C0C0"]
M​
[/td][td="bgcolor:#C0C0C0"]
N​
[/td][td="bgcolor:#C0C0C0"]
O​
[/td][td="bgcolor:#C0C0C0"]
P​
[/td][td="bgcolor:#C0C0C0"]
Q​
[/td][td="bgcolor:#C0C0C0"]
R​
[/td][td="bgcolor:#C0C0C0"]
S​
[/td][td="bgcolor:#C0C0C0"]
T​
[/td][td="bgcolor:#C0C0C0"]
U​
[/td][td="bgcolor:#C0C0C0"]
V​
[/td][td="bgcolor:#C0C0C0"]
W​
[/td][td="bgcolor:#C0C0C0"]
X​
[/td][td="bgcolor:#C0C0C0"]
Y​
[/td][td="bgcolor:#C0C0C0"]
Z​
[/td][td="bgcolor:#C0C0C0"]
AA​
[/td][/tr][tr][td="bgcolor:#C0C0C0"]
1​
[/td][td][/td][td="bgcolor:#F3F3F3"]
A
[/td][td="bgcolor:#F3F3F3"]
B
[/td][td="bgcolor:#F3F3F3"]
C
[/td][td="bgcolor:#F3F3F3"]
D
[/td][td="bgcolor:#F3F3F3"]
E
[/td][td="bgcolor:#F3F3F3"]
F
[/td][td="bgcolor:#F3F3F3"]
G
[/td][td="bgcolor:#F3F3F3"]
H
[/td][td="bgcolor:#F3F3F3"]
I
[/td][td="bgcolor:#F3F3F3"]
J
[/td][td="bgcolor:#F3F3F3"]
K
[/td][td="bgcolor:#F3F3F3"]
L
[/td][td="bgcolor:#F3F3F3"]
M
[/td][td="bgcolor:#F3F3F3"]
N
[/td][td="bgcolor:#F3F3F3"]
O
[/td][td="bgcolor:#F3F3F3"]
P
[/td][td="bgcolor:#F3F3F3"]
Q
[/td][td="bgcolor:#F3F3F3"]
R
[/td][td="bgcolor:#F3F3F3"]
S
[/td][td="bgcolor:#F3F3F3"]
T
[/td][td="bgcolor:#F3F3F3"]
U
[/td][td="bgcolor:#F3F3F3"]
V
[/td][td="bgcolor:#F3F3F3"]
W
[/td][td="bgcolor:#F3F3F3"]
X
[/td][td="bgcolor:#F3F3F3"]
Y
[/td][td="bgcolor:#F3F3F3"]
Z
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
2​
[/td][td="bgcolor:#F3F3F3"]
0
[/td][td]
Z6​
[/td][td]
L3​
[/td][td]
K4​
[/td][td]
O5​
[/td][td]
S7​
[/td][td]
W0​
[/td][td]
G5​
[/td][td]
Y8​
[/td][td]
O9​
[/td][td]
P9​
[/td][td]
E0​
[/td][td]
D7​
[/td][td]
Z2​
[/td][td]
Y0​
[/td][td]
P1​
[/td][td]
U4​
[/td][td]
G9​
[/td][td]
E8​
[/td][td]
E4​
[/td][td]
J5​
[/td][td]
I2​
[/td][td]
F0​
[/td][td]
R9​
[/td][td]
Y5​
[/td][td]
L9​
[/td][td]
L4​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
3​
[/td][td="bgcolor:#F3F3F3"]
1
[/td][td]
H0​
[/td][td]
K5​
[/td][td]
D8​
[/td][td]
T6​
[/td][td]
N2​
[/td][td]
T3​
[/td][td]
J0​
[/td][td]
X9​
[/td][td]
W6​
[/td][td]
Y2​
[/td][td]
B2​
[/td][td]
I0​
[/td][td]
U6​
[/td][td]
Y9​
[/td][td]
A6​
[/td][td]
Y4​
[/td][td]
T8​
[/td][td]
W2​
[/td][td]
V7​
[/td][td]
Y3​
[/td][td]
V1​
[/td][td]
L7​
[/td][td]
Y1​
[/td][td]
F2​
[/td][td]
P3​
[/td][td]
L5​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
4​
[/td][td="bgcolor:#F3F3F3"]
2
[/td][td]
X4​
[/td][td]
Y7​
[/td][td]
U3​
[/td][td]
R3​
[/td][td]
G0​
[/td][td]
X2​
[/td][td]
G4​
[/td][td]
V3​
[/td][td]
T5​
[/td][td]
W3​
[/td][td]
A4​
[/td][td]
L2​
[/td][td]
I5​
[/td][td]
B1​
[/td][td]
P8​
[/td][td]
G8​
[/td][td]
M2​
[/td][td]
Z3​
[/td][td]
A5​
[/td][td]
N1​
[/td][td]
U7​
[/td][td]
Q1​
[/td][td]
F1​
[/td][td]
F7​
[/td][td]
A1​
[/td][td]
S1​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
5​
[/td][td="bgcolor:#F3F3F3"]
3
[/td][td]
H3​
[/td][td]
Q7​
[/td][td]
Q0​
[/td][td]
V9​
[/td][td]
E6​
[/td][td]
N6​
[/td][td]
I9​
[/td][td]
X7​
[/td][td]
F8​
[/td][td]
A7​
[/td][td]
V2​
[/td][td]
C0​
[/td][td]
J4​
[/td][td]
N0​
[/td][td]
M7​
[/td][td]
H5​
[/td][td]
E3​
[/td][td]
S4​
[/td][td]
H6​
[/td][td]
F5​
[/td][td]
P0​
[/td][td]
B0​
[/td][td]
Q5​
[/td][td]
S0​
[/td][td]
X8​
[/td][td]
V6​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
6​
[/td][td="bgcolor:#F3F3F3"]
4
[/td][td]
B3​
[/td][td]
J7​
[/td][td]
R6​
[/td][td]
R8​
[/td][td]
Z1​
[/td][td]
S9​
[/td][td]
U0​
[/td][td]
E2​
[/td][td]
E5​
[/td][td]
H9​
[/td][td]
K8​
[/td][td]
C7​
[/td][td]
U5​
[/td][td]
W1​
[/td][td]
M1​
[/td][td]
Y6​
[/td][td]
L6​
[/td][td]
R7​
[/td][td]
S5​
[/td][td]
H7​
[/td][td]
D2​
[/td][td]
K9​
[/td][td]
Q4​
[/td][td]
D1​
[/td][td]
M4​
[/td][td]
G3​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
7​
[/td][td="bgcolor:#F3F3F3"]
5
[/td][td]
S8​
[/td][td]
B9​
[/td][td]
V8​
[/td][td]
C1​
[/td][td]
A3​
[/td][td]
K7​
[/td][td]
M8​
[/td][td]
D6​
[/td][td]
F9​
[/td][td]
O8​
[/td][td]
Z9​
[/td][td]
K2​
[/td][td]
K0​
[/td][td]
T4​
[/td][td]
J1​
[/td][td]
E7​
[/td][td]
C5​
[/td][td]
K3​
[/td][td]
D9​
[/td][td]
X5​
[/td][td]
R0​
[/td][td]
M6​
[/td][td]
L1​
[/td][td]
R5​
[/td][td]
N3​
[/td][td]
X0​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
8​
[/td][td="bgcolor:#F3F3F3"]
6
[/td][td]
V4​
[/td][td]
N8​
[/td][td]
B8​
[/td][td]
O7​
[/td][td]
C9​
[/td][td]
M0​
[/td][td]
W8​
[/td][td]
Z8​
[/td][td]
D5​
[/td][td]
P2​
[/td][td]
N4​
[/td][td]
U1​
[/td][td]
W7​
[/td][td]
N7​
[/td][td]
A0​
[/td][td]
H2​
[/td][td]
Q9​
[/td][td]
S6​
[/td][td]
M9​
[/td][td]
W5​
[/td][td]
G2​
[/td][td]
O3​
[/td][td]
K6​
[/td][td]
B4​
[/td][td]
Z5​
[/td][td]
U9​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
9​
[/td][td="bgcolor:#F3F3F3"]
7
[/td][td]
Q2​
[/td][td]
J8​
[/td][td]
G6​
[/td][td]
R1​
[/td][td]
F3​
[/td][td]
O1​
[/td][td]
P5​
[/td][td]
J2​
[/td][td]
T2​
[/td][td]
H8​
[/td][td]
K1​
[/td][td]
S3​
[/td][td]
J6​
[/td][td]
W4​
[/td][td]
C2​
[/td][td]
V0​
[/td][td]
C3​
[/td][td]
U8​
[/td][td]
T7​
[/td][td]
H1​
[/td][td]
D0​
[/td][td]
D3​
[/td][td]
M5​
[/td][td]
I8​
[/td][td]
P7​
[/td][td]
N9​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
10​
[/td][td="bgcolor:#F3F3F3"]
8
[/td][td]
J3​
[/td][td]
B7​
[/td][td]
I7​
[/td][td]
N5​
[/td][td]
P6​
[/td][td]
A8​
[/td][td]
R2​
[/td][td]
L8​
[/td][td]
I6​
[/td][td]
I4​
[/td][td]
L0​
[/td][td]
Q6​
[/td][td]
U2​
[/td][td]
X1​
[/td][td]
I1​
[/td][td]
H4​
[/td][td]
B6​
[/td][td]
O6​
[/td][td]
O0​
[/td][td]
C6​
[/td][td]
X3​
[/td][td]
V5​
[/td][td]
C8​
[/td][td]
Z4​
[/td][td]
Q8​
[/td][td]
R4​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
11​
[/td][td="bgcolor:#F3F3F3"]
9
[/td][td]
G1​
[/td][td]
O4​
[/td][td]
O2​
[/td][td]
Q3​
[/td][td]
T9​
[/td][td]
A2​
[/td][td]
J9​
[/td][td]
P4​
[/td][td]
B5​
[/td][td]
A9​
[/td][td]
C4​
[/td][td]
T0​
[/td][td]
T1​
[/td][td]
Z0​
[/td][td]
I3​
[/td][td]
F6​
[/td][td]
E1​
[/td][td]
E9​
[/td][td]
F4​
[/td][td]
M3​
[/td][td]
S2​
[/td][td]
G7​
[/td][td]
D4​
[/td][td]
X6​
[/td][td]
Z7​
[/td][td]
W9​
[/td][/tr]
[/table]
 
Upvote 0
So for example, you want a result like this?

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #C0C0C0"][/TD]
[TD="bgcolor: #C0C0C0"]
A​
[/TD]
[TD="bgcolor: #C0C0C0"]
B​
[/TD]
[TD="bgcolor: #C0C0C0"]
C​
[/TD]
[TD="bgcolor: #C0C0C0"]
D​
[/TD]
[TD="bgcolor: #C0C0C0"]
E​
[/TD]
[TD="bgcolor: #C0C0C0"]
F​
[/TD]
[TD="bgcolor: #C0C0C0"]
G​
[/TD]
[TD="bgcolor: #C0C0C0"]
H​
[/TD]
[TD="bgcolor: #C0C0C0"]
I​
[/TD]
[TD="bgcolor: #C0C0C0"]
J​
[/TD]
[TD="bgcolor: #C0C0C0"]
K​
[/TD]
[TD="bgcolor: #C0C0C0"]
L​
[/TD]
[TD="bgcolor: #C0C0C0"]
M​
[/TD]
[TD="bgcolor: #C0C0C0"]
N​
[/TD]
[TD="bgcolor: #C0C0C0"]
O​
[/TD]
[TD="bgcolor: #C0C0C0"]
P​
[/TD]
[TD="bgcolor: #C0C0C0"]
Q​
[/TD]
[TD="bgcolor: #C0C0C0"]
R​
[/TD]
[TD="bgcolor: #C0C0C0"]
S​
[/TD]
[TD="bgcolor: #C0C0C0"]
T​
[/TD]
[TD="bgcolor: #C0C0C0"]
U​
[/TD]
[TD="bgcolor: #C0C0C0"]
V​
[/TD]
[TD="bgcolor: #C0C0C0"]
W​
[/TD]
[TD="bgcolor: #C0C0C0"]
X​
[/TD]
[TD="bgcolor: #C0C0C0"]
Y​
[/TD]
[TD="bgcolor: #C0C0C0"]
Z​
[/TD]
[TD="bgcolor: #C0C0C0"]
AA​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
1​
[/TD]
[TD][/TD]
[TD="bgcolor: #F3F3F3"]
A
[/TD]
[TD="bgcolor: #F3F3F3"]
B
[/TD]
[TD="bgcolor: #F3F3F3"]
C
[/TD]
[TD="bgcolor: #F3F3F3"]
D
[/TD]
[TD="bgcolor: #F3F3F3"]
E
[/TD]
[TD="bgcolor: #F3F3F3"]
F
[/TD]
[TD="bgcolor: #F3F3F3"]
G
[/TD]
[TD="bgcolor: #F3F3F3"]
H
[/TD]
[TD="bgcolor: #F3F3F3"]
I
[/TD]
[TD="bgcolor: #F3F3F3"]
J
[/TD]
[TD="bgcolor: #F3F3F3"]
K
[/TD]
[TD="bgcolor: #F3F3F3"]
L
[/TD]
[TD="bgcolor: #F3F3F3"]
M
[/TD]
[TD="bgcolor: #F3F3F3"]
N
[/TD]
[TD="bgcolor: #F3F3F3"]
O
[/TD]
[TD="bgcolor: #F3F3F3"]
P
[/TD]
[TD="bgcolor: #F3F3F3"]
Q
[/TD]
[TD="bgcolor: #F3F3F3"]
R
[/TD]
[TD="bgcolor: #F3F3F3"]
S
[/TD]
[TD="bgcolor: #F3F3F3"]
T
[/TD]
[TD="bgcolor: #F3F3F3"]
U
[/TD]
[TD="bgcolor: #F3F3F3"]
V
[/TD]
[TD="bgcolor: #F3F3F3"]
W
[/TD]
[TD="bgcolor: #F3F3F3"]
X
[/TD]
[TD="bgcolor: #F3F3F3"]
Y
[/TD]
[TD="bgcolor: #F3F3F3"]
Z
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
2​
[/TD]
[TD="bgcolor: #F3F3F3"]
0
[/TD]
[TD]
Z6​
[/TD]
[TD]
L3​
[/TD]
[TD]
K4​
[/TD]
[TD]
O5​
[/TD]
[TD]
S7​
[/TD]
[TD]
W0​
[/TD]
[TD]
G5​
[/TD]
[TD]
Y8​
[/TD]
[TD]
O9​
[/TD]
[TD]
P9​
[/TD]
[TD]
E0​
[/TD]
[TD]
D7​
[/TD]
[TD]
Z2​
[/TD]
[TD]
Y0​
[/TD]
[TD]
P1​
[/TD]
[TD]
U4​
[/TD]
[TD]
G9​
[/TD]
[TD]
E8​
[/TD]
[TD]
E4​
[/TD]
[TD]
J5​
[/TD]
[TD]
I2​
[/TD]
[TD]
F0​
[/TD]
[TD]
R9​
[/TD]
[TD]
Y5​
[/TD]
[TD]
L9​
[/TD]
[TD]
L4​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
3​
[/TD]
[TD="bgcolor: #F3F3F3"]
1
[/TD]
[TD]
H0​
[/TD]
[TD]
K5​
[/TD]
[TD]
D8​
[/TD]
[TD]
T6​
[/TD]
[TD]
N2​
[/TD]
[TD]
T3​
[/TD]
[TD]
J0​
[/TD]
[TD]
X9​
[/TD]
[TD]
W6​
[/TD]
[TD]
Y2​
[/TD]
[TD]
B2​
[/TD]
[TD]
I0​
[/TD]
[TD]
U6​
[/TD]
[TD]
Y9​
[/TD]
[TD]
A6​
[/TD]
[TD]
Y4​
[/TD]
[TD]
T8​
[/TD]
[TD]
W2​
[/TD]
[TD]
V7​
[/TD]
[TD]
Y3​
[/TD]
[TD]
V1​
[/TD]
[TD]
L7​
[/TD]
[TD]
Y1​
[/TD]
[TD]
F2​
[/TD]
[TD]
P3​
[/TD]
[TD]
L5​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
4​
[/TD]
[TD="bgcolor: #F3F3F3"]
2
[/TD]
[TD]
X4​
[/TD]
[TD]
Y7​
[/TD]
[TD]
U3​
[/TD]
[TD]
R3​
[/TD]
[TD]
G0​
[/TD]
[TD]
X2​
[/TD]
[TD]
G4​
[/TD]
[TD]
V3​
[/TD]
[TD]
T5​
[/TD]
[TD]
W3​
[/TD]
[TD]
A4​
[/TD]
[TD]
L2​
[/TD]
[TD]
I5​
[/TD]
[TD]
B1​
[/TD]
[TD]
P8​
[/TD]
[TD]
G8​
[/TD]
[TD]
M2​
[/TD]
[TD]
Z3​
[/TD]
[TD]
A5​
[/TD]
[TD]
N1​
[/TD]
[TD]
U7​
[/TD]
[TD]
Q1​
[/TD]
[TD]
F1​
[/TD]
[TD]
F7​
[/TD]
[TD]
A1​
[/TD]
[TD]
S1​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
5​
[/TD]
[TD="bgcolor: #F3F3F3"]
3
[/TD]
[TD]
H3​
[/TD]
[TD]
Q7​
[/TD]
[TD]
Q0​
[/TD]
[TD]
V9​
[/TD]
[TD]
E6​
[/TD]
[TD]
N6​
[/TD]
[TD]
I9​
[/TD]
[TD]
X7​
[/TD]
[TD]
F8​
[/TD]
[TD]
A7​
[/TD]
[TD]
V2​
[/TD]
[TD]
C0​
[/TD]
[TD]
J4​
[/TD]
[TD]
N0​
[/TD]
[TD]
M7​
[/TD]
[TD]
H5​
[/TD]
[TD]
E3​
[/TD]
[TD]
S4​
[/TD]
[TD]
H6​
[/TD]
[TD]
F5​
[/TD]
[TD]
P0​
[/TD]
[TD]
B0​
[/TD]
[TD]
Q5​
[/TD]
[TD]
S0​
[/TD]
[TD]
X8​
[/TD]
[TD]
V6​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
6​
[/TD]
[TD="bgcolor: #F3F3F3"]
4
[/TD]
[TD]
B3​
[/TD]
[TD]
J7​
[/TD]
[TD]
R6​
[/TD]
[TD]
R8​
[/TD]
[TD]
Z1​
[/TD]
[TD]
S9​
[/TD]
[TD]
U0​
[/TD]
[TD]
E2​
[/TD]
[TD]
E5​
[/TD]
[TD]
H9​
[/TD]
[TD]
K8​
[/TD]
[TD]
C7​
[/TD]
[TD]
U5​
[/TD]
[TD]
W1​
[/TD]
[TD]
M1​
[/TD]
[TD]
Y6​
[/TD]
[TD]
L6​
[/TD]
[TD]
R7​
[/TD]
[TD]
S5​
[/TD]
[TD]
H7​
[/TD]
[TD]
D2​
[/TD]
[TD]
K9​
[/TD]
[TD]
Q4​
[/TD]
[TD]
D1​
[/TD]
[TD]
M4​
[/TD]
[TD]
G3​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
7​
[/TD]
[TD="bgcolor: #F3F3F3"]
5
[/TD]
[TD]
S8​
[/TD]
[TD]
B9​
[/TD]
[TD]
V8​
[/TD]
[TD]
C1​
[/TD]
[TD]
A3​
[/TD]
[TD]
K7​
[/TD]
[TD]
M8​
[/TD]
[TD]
D6​
[/TD]
[TD]
F9​
[/TD]
[TD]
O8​
[/TD]
[TD]
Z9​
[/TD]
[TD]
K2​
[/TD]
[TD]
K0​
[/TD]
[TD]
T4​
[/TD]
[TD]
J1​
[/TD]
[TD]
E7​
[/TD]
[TD]
C5​
[/TD]
[TD]
K3​
[/TD]
[TD]
D9​
[/TD]
[TD]
X5​
[/TD]
[TD]
R0​
[/TD]
[TD]
M6​
[/TD]
[TD]
L1​
[/TD]
[TD]
R5​
[/TD]
[TD]
N3​
[/TD]
[TD]
X0​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
8​
[/TD]
[TD="bgcolor: #F3F3F3"]
6
[/TD]
[TD]
V4​
[/TD]
[TD]
N8​
[/TD]
[TD]
B8​
[/TD]
[TD]
O7​
[/TD]
[TD]
C9​
[/TD]
[TD]
M0​
[/TD]
[TD]
W8​
[/TD]
[TD]
Z8​
[/TD]
[TD]
D5​
[/TD]
[TD]
P2​
[/TD]
[TD]
N4​
[/TD]
[TD]
U1​
[/TD]
[TD]
W7​
[/TD]
[TD]
N7​
[/TD]
[TD]
A0​
[/TD]
[TD]
H2​
[/TD]
[TD]
Q9​
[/TD]
[TD]
S6​
[/TD]
[TD]
M9​
[/TD]
[TD]
W5​
[/TD]
[TD]
G2​
[/TD]
[TD]
O3​
[/TD]
[TD]
K6​
[/TD]
[TD]
B4​
[/TD]
[TD]
Z5​
[/TD]
[TD]
U9​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
9​
[/TD]
[TD="bgcolor: #F3F3F3"]
7
[/TD]
[TD]
Q2​
[/TD]
[TD]
J8​
[/TD]
[TD]
G6​
[/TD]
[TD]
R1​
[/TD]
[TD]
F3​
[/TD]
[TD]
O1​
[/TD]
[TD]
P5​
[/TD]
[TD]
J2​
[/TD]
[TD]
T2​
[/TD]
[TD]
H8​
[/TD]
[TD]
K1​
[/TD]
[TD]
S3​
[/TD]
[TD]
J6​
[/TD]
[TD]
W4​
[/TD]
[TD]
C2​
[/TD]
[TD]
V0​
[/TD]
[TD]
C3​
[/TD]
[TD]
U8​
[/TD]
[TD]
T7​
[/TD]
[TD]
H1​
[/TD]
[TD]
D0​
[/TD]
[TD]
D3​
[/TD]
[TD]
M5​
[/TD]
[TD]
I8​
[/TD]
[TD]
P7​
[/TD]
[TD]
N9​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
10​
[/TD]
[TD="bgcolor: #F3F3F3"]
8
[/TD]
[TD]
J3​
[/TD]
[TD]
B7​
[/TD]
[TD]
I7​
[/TD]
[TD]
N5​
[/TD]
[TD]
P6​
[/TD]
[TD]
A8​
[/TD]
[TD]
R2​
[/TD]
[TD]
L8​
[/TD]
[TD]
I6​
[/TD]
[TD]
I4​
[/TD]
[TD]
L0​
[/TD]
[TD]
Q6​
[/TD]
[TD]
U2​
[/TD]
[TD]
X1​
[/TD]
[TD]
I1​
[/TD]
[TD]
H4​
[/TD]
[TD]
B6​
[/TD]
[TD]
O6​
[/TD]
[TD]
O0​
[/TD]
[TD]
C6​
[/TD]
[TD]
X3​
[/TD]
[TD]
V5​
[/TD]
[TD]
C8​
[/TD]
[TD]
Z4​
[/TD]
[TD]
Q8​
[/TD]
[TD]
R4​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]
11​
[/TD]
[TD="bgcolor: #F3F3F3"]
9
[/TD]
[TD]
G1​
[/TD]
[TD]
O4​
[/TD]
[TD]
O2​
[/TD]
[TD]
Q3​
[/TD]
[TD]
T9​
[/TD]
[TD]
A2​
[/TD]
[TD]
J9​
[/TD]
[TD]
P4​
[/TD]
[TD]
B5​
[/TD]
[TD]
A9​
[/TD]
[TD]
C4​
[/TD]
[TD]
T0​
[/TD]
[TD]
T1​
[/TD]
[TD]
Z0​
[/TD]
[TD]
I3​
[/TD]
[TD]
F6​
[/TD]
[TD]
E1​
[/TD]
[TD]
E9​
[/TD]
[TD]
F4​
[/TD]
[TD]
M3​
[/TD]
[TD]
S2​
[/TD]
[TD]
G7​
[/TD]
[TD]
D4​
[/TD]
[TD]
X6​
[/TD]
[TD]
Z7​
[/TD]
[TD]
W9​
[/TD]
[/TR]
</tbody>[/TABLE]


That is close and very nice but actually would like to have just a single letter and/or number. Basically a single result but if a number between 0-9 or letter between a-z would be random. Does that make sense?
 
Upvote 0
If that were true, there are 260 table entries but only 36 possibilities, so there would be multiple repeats of each.
 
Upvote 0
Repeats are okay and possible for what my use would be.

For example, using your gird above:

If I had a coin from Denmark that I paid $575 for and want to mark this on the coin flip but do not want prospective buyers to know my original purchase price I would write Q0V8Q0

If you can think of a better way to do this, I would be more than happy and appreciative. The reason for random generation is so that the code would remain secret. I guess I can see that by repeating Q) for 5 could assist someone in figuring out code. I just thought that a single letter or number would be easier. Perhaps adding capitals and lower case would help?
 
Upvote 0
What are the min and max values you're trying to encode?
 
Upvote 0

Forum statistics

Threads
1,223,711
Messages
6,174,025
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top