Random numbers without repeat in each column and row

I need to generate random numbers range between 1 to 8 without repeat. When user generate the numbers again, the numbers should not repeat in same row. 4 columns needed.

Example:
2 8 4 7
4 6 3 1
3 5 2 6
7 1 6 2
1 7 5 8
6 3 1 5
5 4 8 3
8 2 7 4

I tried with some formulas but I am not very good.

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.