generate 8 numbers between 1-8. no duplicates

Use the randomize function in Excel and add a control to see if the previously generated number is not already present
Playing Sudoku? with 8 numbers?

Hi businpro,

See the attached where I think I have your answer. Sort by the random numbers in column B and see the 4 tables above change and meet what you want.

Partner pair sorts for 4 groups.xlsx

That's a blocked site

Sulprobil - please read this forum's rules, in particular this one:

13b. Do not put links to personal sites or services as your sole contribution here on the forum.

If the only thing you have to offer, even in the Water Cooler and Tools/Tips sections, is links to your own blogs or personal sites/services, let us respectfully say, "No thank you." This is not meant personally, but the Excel Forum is a community, if you wish to participate substantively within this community, then do so.
Posting links to your free tools and tips directly in the threads of our questioners is acceptable if it represents less than 10% of your contributions. Thus, we only expect to see you pointing people to your own free links 1 in 10 posts, if that.
Earn your stripes helping directly the way we all do, then the linking for common tasks is natural and acceptable.

Your sole contribution to this forum is information about your site. You have not yet earned your stripes, so please do not publicise it again until you have.