creating random letters that dont repeat in rows or columns

[kinski]

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!

 

[Scott Huish]

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
	D	E	F	G	H
1	p	s	a	n	b
2	g	q	m	k	w
3	f	y	v	u	j
4	o	i	c	x	t
5	d	l	h	e	r
Sheet

Excel Workbook
	N	O	P	Q	R
1	0.388147	0.206773	0.933327	0.419481	0.932041
2	0.784351	0.319034	0.441037	0.63129	0.115221
3	0.79909	0.071984	0.164645	0.189943	0.641197
4	0.410898	0.644203	0.926066	0.109661	0.190882
5	0.866947	0.49939	0.720357	0.838679	0.316075
6	0.339922	0.93892	0.664976	0.115513	0.878312
Sheet

Hit F9 to generate new sets.