in A1:B4 i have numbers 1-8. In A5:B8 i want generate the same numbers in a random order where the same 2 numbers never appear on the same row for the next three 3 tables
in A1:B4 i have numbers 1-8. In A5:B8 i want generate the same numbers in a random order where the same 2 numbers never appear on the same row for the next three 3 tables
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?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
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
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
That's a blocked site
Sulprobil - please read this forum's rules, in particular this one:
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.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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks