Random single letter/digit grid

[rtrnow61]

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.

 

[shg]

Can you give an example of what you want to do?

 

[rtrnow61]

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

 

[rtrnow61]

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

 

[shg]

So for example, you want a result like this?

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​

AA​

1​

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​

2​

0​

Z6​

L3​

K4​

O5​

S7​

W0​

G5​

Y8​

O9​

P9​

E0​

D7​

Z2​

Y0​

P1​

U4​

G9​

E8​

E4​

J5​

I2​

F0​

R9​

Y5​

L9​

L4​

3​

1​

H0​

K5​

D8​

T6​

N2​

T3​

J0​

X9​

W6​

Y2​

B2​

I0​

U6​

Y9​

A6​

Y4​

T8​

W2​

V7​

Y3​

V1​

L7​

Y1​

F2​

P3​

L5​

4​

2​

X4​

Y7​

U3​

R3​

G0​

X2​

G4​

V3​

T5​

W3​

A4​

L2​

I5​

B1​

P8​

G8​

M2​

Z3​

A5​

N1​

U7​

Q1​

F1​

F7​

A1​

S1​

5​

3​

H3​

Q7​

Q0​

V9​

E6​

N6​

I9​

X7​

F8​

A7​

V2​

C0​

J4​

N0​

M7​

H5​

E3​

S4​

H6​

F5​

P0​

B0​

Q5​

S0​

X8​

V6​

6​

4​

B3​

J7​

R6​

R8​

Z1​

S9​

U0​

E2​

E5​

H9​

K8​

C7​

U5​

W1​

M1​

Y6​

L6​

R7​

S5​

H7​

D2​

K9​

Q4​

D1​

M4​

G3​

7​

5​

S8​

B9​

V8​

C1​

A3​

K7​

M8​

D6​

F9​

O8​

Z9​

K2​

K0​

T4​

J1​

E7​

C5​

K3​

D9​

X5​

R0​

M6​

L1​

R5​

N3​

X0​

8​

6​

V4​

N8​

B8​

O7​

C9​

M0​

W8​

Z8​

D5​

P2​

N4​

U1​

W7​

N7​

A0​

H2​

Q9​

S6​

M9​

W5​

G2​

O3​

K6​

B4​

Z5​

U9​

9​

7​

Q2​

J8​

G6​

R1​

F3​

O1​

P5​

J2​

T2​

H8​

K1​

S3​

J6​

W4​

C2​

V0​

C3​

U8​

T7​

H1​

D0​

D3​

M5​

I8​

P7​

N9​

10​

8​

J3​

B7​

I7​

N5​

P6​

A8​

R2​

L8​

I6​

I4​

L0​

Q6​

U2​

X1​

I1​

H4​

B6​

O6​

O0​

C6​

X3​

V5​

C8​

Z4​

Q8​

R4​

11​

9​

G1​

O4​

O2​

Q3​

T9​

A2​

J9​

P4​

B5​

A9​

C4​

T0​

T1​

Z0​

I3​

F6​

E1​

E9​

F4​

M3​

S2​

G7​

D4​

X6​

Z7​

W9​

 

[rtrnow61]

So for example, you want a result like this?

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​

AA​

1​

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​

2​

0​

Z6​

L3​

K4​

O5​

S7​

W0​

G5​

Y8​

O9​

P9​

E0​

D7​

Z2​

Y0​

P1​

U4​

G9​

E8​

E4​

J5​

I2​

F0​

R9​

Y5​

L9​

L4​

3​

1​

H0​

K5​

D8​

T6​

N2​

T3​

J0​

X9​

W6​

Y2​

B2​

I0​

U6​

Y9​

A6​

Y4​

T8​

W2​

V7​

Y3​

V1​

L7​

Y1​

F2​

P3​

L5​

4​

2​

X4​

Y7​

U3​

R3​

G0​

X2​

G4​

V3​

T5​

W3​

A4​

L2​

I5​

B1​

P8​

G8​

M2​

Z3​

A5​

N1​

U7​

Q1​

F1​

F7​

A1​

S1​

5​

3​

H3​

Q7​

Q0​

V9​

E6​

N6​

I9​

X7​

F8​

A7​

V2​

C0​

J4​

N0​

M7​

H5​

E3​

S4​

H6​

F5​

P0​

B0​

Q5​

S0​

X8​

V6​

6​

4​

B3​

J7​

R6​

R8​

Z1​

S9​

U0​

E2​

E5​

H9​

K8​

C7​

U5​

W1​

M1​

Y6​

L6​

R7​

S5​

H7​

D2​

K9​

Q4​

D1​

M4​

G3​

7​

5​

S8​

B9​

V8​

C1​

A3​

K7​

M8​

D6​

F9​

O8​

Z9​

K2​

K0​

T4​

J1​

E7​

C5​

K3​

D9​

X5​

R0​

M6​

L1​

R5​

N3​

X0​

8​

6​

V4​

N8​

B8​

O7​

C9​

M0​

W8​

Z8​

D5​

P2​

N4​

U1​

W7​

N7​

A0​

H2​

Q9​

S6​

M9​

W5​

G2​

O3​

K6​

B4​

Z5​

U9​

9​

7​

Q2​

J8​

G6​

R1​

F3​

O1​

P5​

J2​

T2​

H8​

K1​

S3​

J6​

W4​

C2​

V0​

C3​

U8​

T7​

H1​

D0​

D3​

M5​

I8​

P7​

N9​

10​

8​

J3​

B7​

I7​

N5​

P6​

A8​

R2​

L8​

I6​

I4​

L0​

Q6​

U2​

X1​

I1​

H4​

B6​

O6​

O0​

C6​

X3​

V5​

C8​

Z4​

Q8​

R4​

11​

9​

G1​

O4​

O2​

Q3​

T9​

A2​

J9​

P4​

B5​

A9​

C4​

T0​

T1​

Z0​

I3​

F6​

E1​

E9​

F4​

M3​

S2​

G7​

D4​

X6​

Z7​

W9​

<tbody>
</tbody>

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?

 

[shg]

If that were true, there are 260 table entries but only 36 possibilities, so there would be multiple repeats of each.

 

[rtrnow61]

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?

 

[rtrnow61]

D5=q0
d7=v8
d5=q0

 

[shg]

What are the min and max values you're trying to encode?