creating random letters that dont repeat in rows or columns

kinski

New Member
Joined
Sep 6, 2007
Messages
1
Hello to all!
I need to create a matrix of a-z in rows and columns, with the table filled with random letters that dont repeat. Sudoku style :) I have tried for 4 hours now, and no luck. Can anyone help? Thanks in advance!
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
You didn't say how many rows and columns, so I am making a 5x5 grid.

Somewhere on your sheet, in the same dimensions as your grid, fill with the formula =RAND()
I used N1:R5

Formula in D1:
=CHAR(96+RANK(N1,$N$1:$R$5))
Copy down to row 5 and across to column H.
Excel Workbook
DEFGH
1psanb
2gqmkw
3fyvuj
4oicxt
5dlher
Sheet
Excel Workbook
NOPQR
10.3881470.2067730.9333270.4194810.932041
20.7843510.3190340.4410370.631290.115221
30.799090.0719840.1646450.1899430.641197
40.4108980.6442030.9260660.1096610.190882
50.8669470.499390.7203570.8386790.316075
60.3399220.938920.6649760.1155130.878312
Sheet


Hit F9 to generate new sets.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,809
Messages
5,598,202
Members
414,218
Latest member
speedbit

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
Top