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.

 

[rtrnow61]

Thank you very much for doing what you can to assist. I have been perplexed with this issue for quite some time and when I came across the YouTube video of Mr. Excel I thought that something similar would be possible. Thank you for your help and replies!

 

[rtrnow61]

Likely nothing more than 10000 but at 1000 I am sure I could come up with a way to make it exponential.

 

[rtrnow61]

Sorry, min would be 10

 

[shg]

Consider 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​

10.00​

14.27​

20.36​

29.06​

41.47​

59.18​

84.46​

120.53​

172.00​

245.45​

350.27​

499.85​

713.32​

1017.94​

1452.65​

2073.01​

2958.30​

4221.65​

6024.52​

8597.32​

12268.83​

17508.27​

24985.23​

35655.26​

50881.95​

72611.24​

3​

1​

10.36​

14.79​

21.10​

30.11​

42.97​

61.33​

87.52​

124.89​

178.22​

254.33​

362.95​

517.95​

739.14​

1054.79​

1505.24​

2148.06​

3065.40​

4374.48​

6242.62​

8908.55​

12712.97​

18142.09​

25889.72​

36946.01​

52723.92​

75239.84​

4​

2​

10.74​

15.32​

21.87​

31.20​

44.53​

63.55​

90.68​

129.41​

184.68​

263.54​

376.09​

536.70​

765.90​

1092.97​

1559.73​

2225.82​

3176.37​

4532.84​

6468.61​

9231.05​

13173.19​

18798.85​

26826.96​

38283.50​

54632.58​

77963.60​

5​

3​

11.13​

15.88​

22.66​

32.33​

46.14​

65.85​

93.97​

134.10​

191.36​

273.08​

389.70​

556.13​

793.62​

1132.54​

1616.20​

2306.40​

3291.35​

4696.94​

6702.78​

9565.22​

13650.08​

19479.39​

27798.12​

39669.40​

56610.34​

80785.96​

6​

4​

11.53​

16.45​

23.48​

33.50​

47.81​

68.23​

97.37​

138.95​

198.29​

282.97​

403.81​

576.26​

822.35​

1173.54​

1674.70​

2389.89​

3410.50​

4866.97​

6945.43​

9911.49​

14144.22​

20184.56​

28804.44​

41105.47​

58659.69​

83710.50​

7​

5​

11.95​

17.05​

24.33​

34.72​

49.54​

70.70​

100.89​

143.98​

205.47​

293.21​

418.43​

597.12​

852.12​

1216.02​

1735.33​

2476.41​

3533.97​

5043.16​

7196.86​

10270.30​

14656.26​

20915.26​

29847.19​

42593.53​

60783.23​

86740.90​

8​

6​

12.38​

17.66​

25.21​

35.97​

51.34​

73.26​

104.55​

149.19​

212.90​

303.83​

433.58​

618.74​

882.97​

1260.05​

1798.15​

2566.06​

3661.90​

5225.73​

7457.39​

10642.09​

15186.83​

21672.42​

30927.69​

44135.46​

62983.65​

89881.01​

9​

7​

12.83​

18.30​

26.12​

37.28​

53.19​

75.91​

108.33​

154.59​

220.61​

314.83​

449.27​

641.14​

914.93​

1305.66​

1863.25​

2658.95​

3794.47​

5414.90​

7727.36​

11027.35​

15736.61​

22456.98​

32047.30​

45733.21​

65263.72​

93134.80​

10​

8​

13.29​

18.97​

27.07​

38.63​

55.12​

78.66​

112.25​

160.19​

228.60​

326.22​

465.54​

664.35​

948.06​

1352.93​

1930.70​

2755.21​

3931.83​

5610.93​

8007.09​

11426.55​

16306.29​

23269.95​

33207.45​

47388.80​

67626.33​

96506.37​

11​

9​

13.77​

19.65​

28.05​

40.02​

57.12​

81.51​

116.32​

165.99​

236.87​

338.03​

482.39​

688.40​

982.38​

1401.90​

2000.59​

2854.95​

4074.16​

5814.05​

8296.96​

11840.20​

16896.60​

24112.34​

34409.59​

49104.32​

70074.47​

100000.00​

It contains all costs from $10 to $10,000 with a step size of 3.6%; is that sufficient accuracy?

Randomized,

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​

32047.30​

433.58​

273.08​

282.97​

17.05​

96506.37​

4074.16​

212.90​

10.36​

2755.21​

11.95​

160.19​

12268.83​

25.21​

1863.25​

41.47​

36946.01​

120.53​

56610.34​

29847.19​

1616.20​

72611.24​

26.12​

124.89​

49.54​

73.26​

3​

1​

982.38​

61.33​

11027.35​

12.38​

3533.97​

556.13​

10.00​

3291.35​

44.53​

12712.97​

19.65​

1216.02​

3410.50​

5043.16​

52723.92​

84.46​

14.27​

28.05​

9565.22​

1798.15​

4532.84​

2389.89​

15736.61​

17508.27​

882.97​

16306.29​

4​

2​

1930.70​

1559.73​

8597.32​

8296.96​

1132.54​

62983.65​

67626.33​

97.37​

26826.96​

108.33​

38.63​

34409.59​

18798.85​

39669.40​

78.66​

14144.22​

70074.47​

87.52​

16896.60​

70.70​

2476.41​

793.62​

13.29​

10642.09​

65.85​

60783.23​

5​

3​

138.95​

32.33​

1173.54​

7457.39​

1305.66​

34.72​

21.10​

27.07​

739.14​

449.27​

21.87​

3931.83​

178.22​

6024.52​

165.99​

75.91​

914.93​

403.81​

28804.44​

8908.55​

63.55​

75239.84​

13650.08​

3661.90​

100.89​

30.11​

6​

4​

129.41​

44135.46​

338.03​

14.79​

40.02​

38283.50​

15.88​

33207.45​

23269.95​

3176.37​

362.95​

2658.95​

24985.23​

9231.05​

1092.97​

2566.06​

822.35​

41105.47​

2306.40​

20184.56​

1352.93​

1505.24​

8007.09​

54632.58​

116.32​

14656.26​

7​

5​

245.45​

42593.53​

1260.05​

303.83​

4374.48​

1401.90​

3065.40​

93134.80​

81.51​

3794.47​

713.32​

465.54​

50881.95​

13173.19​

11.53​

536.70​

100000.00​

21672.42​

15.32​

576.26​

948.06​

4221.65​

10.74​

89881.01​

27798.12​

59.18​

8​

6​

482.39​

191.36​

77963.60​

184.68​

9911.49​

314.83​

22.66​

42.97​

6468.61​

618.74​

418.43​

23.48​

24112.34​

35655.26​

33.50​

19479.39​

154.59​

263.54​

6702.78​

376.09​

236.87​

35.97​

664.35​

57.12​

31.20​

205.47​

9​

7​

688.40​

6945.43​

22456.98​

47388.80​

641.14​

5225.73​

6242.62​

254.33​

2148.06​

45733.21​

18.30​

25889.72​

1017.94​

5814.05​

517.95​

5414.90​

143.98​

49104.32​

51.34​

93.97​

149.19​

24.33​

65263.72​

17.66​

1674.70​

134.10​

10​

8​

2073.01​

112.25​

4696.94​

86740.90​

47.81​

389.70​

2225.82​

4866.97​

499.85​

13.77​

15186.83​

58659.69​

765.90​

2958.30​

55.12​

20.36​

326.22​

2854.95​

29.06​

7196.86​

228.60​

18.97​

293.21​

18142.09​

198.29​

37.28​

11​

9​

172.00​

53.19​

104.55​

2000.59​

11426.55​

12.83​

90.68​

11840.20​

1054.79​

30927.69​

16.45​

597.12​

220.61​

5610.93​

46.14​

10270.30​

83710.50​

20915.26​

11.13​

1452.65​

80785.96​

350.27​

7727.36​

1735.33​

852.12​

68.23​

 

[rtrnow61]

I probably misunderstood your question. with the grid you first sent with 2 digits I would be able to easily go up to $999. Do you see where I am coming from? Can you elaborate on your question since based on what I just stated my minimum using your example sent would be 999

 

[rtrnow61]

Considering that almost all my coins or most peoples probably would be in dollar increments and perhaps down to 50 cents, yours would work but might be hard to keep track of in terms of accuracy. Although I can see it as being complex and random. hmmm

 

[rtrnow61]

Plus giving you my example of a coin from Denmark, thus using the D column, I could not use your latest example. Your first one was good but instead of 2 values just 1 value and that being either a letter or a number. And if capitals and lower case could be included, I think that would be great.

 

[shg]

Again, how about you provide an example of what you want, and how you would use it.

 

[rtrnow61]

Again, how about you provide an example of what you want, and how you would use it.

I actually thought that I have given numerous examples since you first asked. I apologize if I have not been more clear.

Again, if I coin was from Denmark and I paid $125 for it, I want to place a code on the coin flip that would aloow me to know what I paid, in this case, $125 but not to allow anyone else to know what I paid for it.

In the spreadsheet I envision, I would go to the D column and down to the 1 row and pick the letter or number then D2 for that letter or number and then to D5 for that letter or number.

so as an example, $125 could be H2x if those happened to be in the corresponding cells.

Same thing for a coin from the United States that cost me $350
Go to the U column and do the same process as I did with the Denmark coin.

Again, I apologize for not being clearer and I hope I have been concise enough to make my thoughts clear this time. Does what I have explained make sense to you? It is rather difficult to explain something sometimes as I am sure you are aware.

Thank you again for your help.

 

[rtrnow61]

	A	B	C	D	E
0	1	g	5	3	u
1	A	z	3	1	9
2	f	A	C	7	G
3	2	4	X	a	b
4	7	B	c	6	L
5	g	6	3	w	S
6	k	b	2	E	X
7	2	F	V	k	8
8	D	t	q	a	9
9	5	w	8	A	Q

<colgroup><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>

This is just a Just a partial example, the complete alphabet would go across the top. In this case, a coin from Denmark where my purchase price was $215 would be coded as D2 D1 D5 or 71w. I would use 1 instance for some time but the random generation would assist with a given collection or set for example. I would merely need to save any given spreadsheet with an identifier of some type.