Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 23 Apr 2019 13:40:49 +0200How to generate random non-repeating cells from a starting range?https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/So far I have the following to find a random cell value within the column range I got.
=INDEX(Sheet1.A2:A21, RANDBETWEEN(2,21))
The problem is that I haven't been able to figure out how to check for repetitions.
I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit (P(n,r)=P(21,2)
=21!(21−2)!
= 420). Ideally I would do this on the rows and columns following (ex. B2:B21) and would generate 20 more column ranges to cover all permutations. I might be wrong about the number of columns necessary.Fri, 27 Oct 2017 07:45:00 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/Comment by Lupp for <p>So far I have the following to find a random cell value within the column range I got.</p>
<pre><code>=INDEX(Sheet1.A2:A21, RANDBETWEEN(2,21))
</code></pre>
<p>The problem is that I haven't been able to figure out how to check for repetitions.</p>
<p>I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit (P(n,r)=P(21,2)
=21!(21−2)!
= 420). Ideally I would do this on the rows and columns following (ex. B2:B21) and would generate 20 more column ranges to cover all permutations. I might be wrong about the number of columns necessary.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136219#post-id-136219(I don't consider wiki posts recommendable. Looks modest, but also anonymizes.)
I don't understand for sure.
-1- "...create different pairs..." Single pairs or a complete breakdown of a class into pairs?
-2- Do you want to regard the order within each pair? (If so for curiosity: why?)
-3- "Ideally I would do this on the rows and columns following (ex. B2:B21)" Need explanation.
-4- Splitting one kind of information over many columns is mostly supposed to be bad design.Fri, 27 Oct 2017 16:11:11 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136219#post-id-136219Comment by shoegato for <p>So far I have the following to find a random cell value within the column range I got.</p>
<pre><code>=INDEX(Sheet1.A2:A21, RANDBETWEEN(2,21))
</code></pre>
<p>The problem is that I haven't been able to figure out how to check for repetitions.</p>
<p>I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit (P(n,r)=P(21,2)
=21!(21−2)!
= 420). Ideally I would do this on the rows and columns following (ex. B2:B21) and would generate 20 more column ranges to cover all permutations. I might be wrong about the number of columns necessary.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136272#post-id-136272@Lupp for one I meant, A complete breakdown of the class into pairs daily.Sat, 28 Oct 2017 08:42:23 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136272#post-id-136272Comment by shoegato for <p>So far I have the following to find a random cell value within the column range I got.</p>
<pre><code>=INDEX(Sheet1.A2:A21, RANDBETWEEN(2,21))
</code></pre>
<p>The problem is that I haven't been able to figure out how to check for repetitions.</p>
<p>I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit (P(n,r)=P(21,2)
=21!(21−2)!
= 420). Ideally I would do this on the rows and columns following (ex. B2:B21) and would generate 20 more column ranges to cover all permutations. I might be wrong about the number of columns necessary.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136266#post-id-136266(Edited for better readability by @Lupp)
2-- I'm planning for the everyone to work with someone different the first few weeks of class.
3--Every generated column of student pairs would be a week's worth of pairings. One day: X,Y work together and so on. Then next day Y,Z work together.
I know sometimes people are absent so I'll just send my lost lambs to work with a random pair.
4--This is my first time working with spreadsheets. I couldn't think of a more readable way to organize it.Sat, 28 Oct 2017 06:02:47 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136266#post-id-136266Comment by Lupp for <p>So far I have the following to find a random cell value within the column range I got.</p>
<pre><code>=INDEX(Sheet1.A2:A21, RANDBETWEEN(2,21))
</code></pre>
<p>The problem is that I haven't been able to figure out how to check for repetitions.</p>
<p>I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit (P(n,r)=P(21,2)
=21!(21−2)!
= 420). Ideally I would do this on the rows and columns following (ex. B2:B21) and would generate 20 more column ranges to cover all permutations. I might be wrong about the number of columns necessary.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136283#post-id-136283@shoegato:
-a- Sorry. My editing of your comment for better line-wrap replaced your avatar by mine. A **bug of the askbot software**, obviously.
-b- Your statements "-2-", "-3-" don't match my respective questions. However, they clear your requirements and make sense. But: What about a class with an odd number of students? Lost-lamb-factory?
-c- You will find usable approaches in the attachment I created when editing my answer.
-d- Freely comment on my suggestions, please.Sat, 28 Oct 2017 13:13:05 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136283#post-id-136283Comment by shoegato for <p>So far I have the following to find a random cell value within the column range I got.</p>
<pre><code>=INDEX(Sheet1.A2:A21, RANDBETWEEN(2,21))
</code></pre>
<p>The problem is that I haven't been able to figure out how to check for repetitions.</p>
<p>I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit (P(n,r)=P(21,2)
=21!(21−2)!
= 420). Ideally I would do this on the rows and columns following (ex. B2:B21) and would generate 20 more column ranges to cover all permutations. I might be wrong about the number of columns necessary.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136354#post-id-136354@Lupp Thanks. Oh you're right. For 2, I do not need to regard the order within pairs--that does simplify things a whole lot. I just need the unique combos. As for 3, This is what I pictured I would do in my head:
day/date...
n. student pair...
I guess I don't really need columns. I just need to find a way to organize days dates and the pairings for that day. I'm learning to think in spreadsheet and I'm slowly breaking down the demo into pieces I can grok.Sun, 29 Oct 2017 06:42:01 +0100https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136354#post-id-136354Answer by Lupp for <p>So far I have the following to find a random cell value within the column range I got.</p>
<pre><code>=INDEX(Sheet1.A2:A21, RANDBETWEEN(2,21))
</code></pre>
<p>The problem is that I haven't been able to figure out how to check for repetitions.</p>
<p>I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit (P(n,r)=P(21,2)
=21!(21−2)!
= 420). Ideally I would do this on the rows and columns following (ex. B2:B21) and would generate 20 more column ranges to cover all permutations. I might be wrong about the number of columns necessary.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?answer=136206#post-id-136206Besides this askbot site, there is also a forum on open office suites (including LibO) where you can find solutions.
In your case: https://forum.openoffice.org/en/forum/viewtopic.php?t=58665
Section <s>"C."</s> "E." (Sorry!) and the example document attached there apply to your question.
(Editing:)
Though the OQ didn't answer my questions I prepared **[this](/upfiles/15091480827605494.ods)** attached demo.
You may take from it what seems useful to you.
(Edit2 regarding the recent explanations by the OQ:)
To create a new partition-into-pairs is simple using the means I already demonstrated, but I would judge it next to impossible (probable solutions at least very inefficient) to definitely avoid any reoccurring pair by Calc means. If a respective guarantee is needed I would resort to user code. (Also not exactly simple. These comments are based on estimations, of course.)
(Edit2:)
(deleted; was not good)
**Now hopefully better:**
What you actually need has little do do with randomizing. Depending on the preferred words it is nown as a chapter of mathematical graph-theory, or more pragmatically - often needed - the task to schedule (sine-die) the first set of matchdays for a 20-league. In your case the participants are just not expected to fight one another.
Theory: http://www.mathaware.org/mam/2010/essays/FroncekTournament.pdf
Spreadsheets for the task: http://www.excelformeln.de/bilder/Liga-Spielplan.zip
(German; no understanding of the language needed. Simply replace the names.)
(Author's page in that site: http://www.excelformeln.de/uberuns.html?umenuzahl=14&autor=1)
If randomization shall be included you may first of all randomize the order of names (and leave it at that then) or randomize the order of the pairings you want to apply them in (or both).
The linked sheet is in .xls and contains relics of VBA though there is no active code at all. I made an .ods of it without the macro modules ("hard work") and it still did its duty. Of cours you may simply reject permission for macros.Fri, 27 Oct 2017 12:45:35 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?answer=136206#post-id-136206Comment by cornouws for <p>Besides this askbot site, there is also a forum on open office suites (including LibO) where you can find solutions. </p>
<p>In your case: <a href="https://forum.openoffice.org/en/forum/viewtopic.php?t=58665">https://forum.openoffice.org/en/forum...</a> <br>
Section <s>"C."</s> "E." (Sorry!) and the example document attached there apply to your question. </p>
<p>(Editing:) <br>
Though the OQ didn't answer my questions I prepared <strong><a href="/upfiles/15091480827605494.ods">this</a></strong> attached demo. <br>
You may take from it what seems useful to you.</p>
<p>(Edit2 regarding the recent explanations by the OQ:) <br>
To create a new partition-into-pairs is simple using the means I already demonstrated, but I would judge it next to impossible (probable solutions at least very inefficient) to definitely avoid any reoccurring pair by Calc means. If a respective guarantee is needed I would resort to user code. (Also not exactly simple. These comments are based on estimations, of course.) </p>
<p>(Edit2:) <br>
(deleted; was not good) <br>
<strong>Now hopefully better:</strong> <br>
What you actually need has little do do with randomizing. Depending on the preferred words it is nown as a chapter of mathematical graph-theory, or more pragmatically - often needed - the task to schedule (sine-die) the first set of matchdays for a 20-league. In your case the participants are just not expected to fight one another. </p>
<p>Theory: <a href="http://www.mathaware.org/mam/2010/essays/FroncekTournament.pdf">http://www.mathaware.org/mam/2010/ess...</a> <br>Spreadsheets for the task: <a href="http://www.excelformeln.de/bilder/Liga-Spielplan.zip">http://www.excelformeln.de/bilder/Lig...</a> <br>
(German; no understanding of the language needed. Simply replace the names.) <br>(Author's page in that site: <a href="http://www.excelformeln.de/uberuns.html?umenuzahl=14&autor=1">http://www.excelformeln.de/uberuns.ht...</a>) </p>
<p>If randomization shall be included you may first of all randomize the order of names (and leave it at that then) or randomize the order of the pairings you want to apply them in (or both). </p>
<p>The linked sheet is in .xls and contains relics of VBA though there is no active code at all. I made an .ods of it without the macro modules ("hard work") and it still did its duty. Of cours you may simply reject permission for macros.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136208#post-id-136208No need to comment in such a vague an unstructured way on different types of help sites, maybe? Thanks!
<br>So I took freedom to improve your answer.Fri, 27 Oct 2017 13:27:05 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136208#post-id-136208Comment by cornouws for <p>Besides this askbot site, there is also a forum on open office suites (including LibO) where you can find solutions. </p>
<p>In your case: <a href="https://forum.openoffice.org/en/forum/viewtopic.php?t=58665">https://forum.openoffice.org/en/forum...</a> <br>
Section <s>"C."</s> "E." (Sorry!) and the example document attached there apply to your question. </p>
<p>(Editing:) <br>
Though the OQ didn't answer my questions I prepared <strong><a href="/upfiles/15091480827605494.ods">this</a></strong> attached demo. <br>
You may take from it what seems useful to you.</p>
<p>(Edit2 regarding the recent explanations by the OQ:) <br>
To create a new partition-into-pairs is simple using the means I already demonstrated, but I would judge it next to impossible (probable solutions at least very inefficient) to definitely avoid any reoccurring pair by Calc means. If a respective guarantee is needed I would resort to user code. (Also not exactly simple. These comments are based on estimations, of course.) </p>
<p>(Edit2:) <br>
(deleted; was not good) <br>
<strong>Now hopefully better:</strong> <br>
What you actually need has little do do with randomizing. Depending on the preferred words it is nown as a chapter of mathematical graph-theory, or more pragmatically - often needed - the task to schedule (sine-die) the first set of matchdays for a 20-league. In your case the participants are just not expected to fight one another. </p>
<p>Theory: <a href="http://www.mathaware.org/mam/2010/essays/FroncekTournament.pdf">http://www.mathaware.org/mam/2010/ess...</a> <br>Spreadsheets for the task: <a href="http://www.excelformeln.de/bilder/Liga-Spielplan.zip">http://www.excelformeln.de/bilder/Lig...</a> <br>
(German; no understanding of the language needed. Simply replace the names.) <br>(Author's page in that site: <a href="http://www.excelformeln.de/uberuns.html?umenuzahl=14&autor=1">http://www.excelformeln.de/uberuns.ht...</a>) </p>
<p>If randomization shall be included you may first of all randomize the order of names (and leave it at that then) or randomize the order of the pairings you want to apply them in (or both). </p>
<p>The linked sheet is in .xls and contains relics of VBA though there is no active code at all. I made an .ods of it without the macro modules ("hard work") and it still did its duty. Of cours you may simply reject permission for macros.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136211#post-id-136211Obviously: thanks for the extremely helpful part of your answer ;)Fri, 27 Oct 2017 14:38:19 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136211#post-id-136211Comment by Lupp for <p>Besides this askbot site, there is also a forum on open office suites (including LibO) where you can find solutions. </p>
<p>In your case: <a href="https://forum.openoffice.org/en/forum/viewtopic.php?t=58665">https://forum.openoffice.org/en/forum...</a> <br>
Section <s>"C."</s> "E." (Sorry!) and the example document attached there apply to your question. </p>
<p>(Editing:) <br>
Though the OQ didn't answer my questions I prepared <strong><a href="/upfiles/15091480827605494.ods">this</a></strong> attached demo. <br>
You may take from it what seems useful to you.</p>
<p>(Edit2 regarding the recent explanations by the OQ:) <br>
To create a new partition-into-pairs is simple using the means I already demonstrated, but I would judge it next to impossible (probable solutions at least very inefficient) to definitely avoid any reoccurring pair by Calc means. If a respective guarantee is needed I would resort to user code. (Also not exactly simple. These comments are based on estimations, of course.) </p>
<p>(Edit2:) <br>
(deleted; was not good) <br>
<strong>Now hopefully better:</strong> <br>
What you actually need has little do do with randomizing. Depending on the preferred words it is nown as a chapter of mathematical graph-theory, or more pragmatically - often needed - the task to schedule (sine-die) the first set of matchdays for a 20-league. In your case the participants are just not expected to fight one another. </p>
<p>Theory: <a href="http://www.mathaware.org/mam/2010/essays/FroncekTournament.pdf">http://www.mathaware.org/mam/2010/ess...</a> <br>Spreadsheets for the task: <a href="http://www.excelformeln.de/bilder/Liga-Spielplan.zip">http://www.excelformeln.de/bilder/Lig...</a> <br>
(German; no understanding of the language needed. Simply replace the names.) <br>(Author's page in that site: <a href="http://www.excelformeln.de/uberuns.html?umenuzahl=14&autor=1">http://www.excelformeln.de/uberuns.ht...</a>) </p>
<p>If randomization shall be included you may first of all randomize the order of names (and leave it at that then) or randomize the order of the pairings you want to apply them in (or both). </p>
<p>The linked sheet is in .xls and contains relics of VBA though there is no active code at all. I made an .ods of it without the macro modules ("hard work") and it still did its duty. Of cours you may simply reject permission for macros.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136220#post-id-136220@cornouws: Next time I would prefer you critisize commenting pars of my answers you disagree with, and leave it to me to change them where I can accept your view. You may have noticed that I am not a rookie here.
I critisized this site for its lack of helpful structure more than once, and on some occasions I will do so again. You may also have noticed that there are more than one experienced contributors here who are unhappy with things as they are.Fri, 27 Oct 2017 16:19:21 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136220#post-id-136220Comment by Lupp for <p>Besides this askbot site, there is also a forum on open office suites (including LibO) where you can find solutions. </p>
<p>In your case: <a href="https://forum.openoffice.org/en/forum/viewtopic.php?t=58665">https://forum.openoffice.org/en/forum...</a> <br>
Section <s>"C."</s> "E." (Sorry!) and the example document attached there apply to your question. </p>
<p>(Editing:) <br>
Though the OQ didn't answer my questions I prepared <strong><a href="/upfiles/15091480827605494.ods">this</a></strong> attached demo. <br>
You may take from it what seems useful to you.</p>
<p>(Edit2 regarding the recent explanations by the OQ:) <br>
To create a new partition-into-pairs is simple using the means I already demonstrated, but I would judge it next to impossible (probable solutions at least very inefficient) to definitely avoid any reoccurring pair by Calc means. If a respective guarantee is needed I would resort to user code. (Also not exactly simple. These comments are based on estimations, of course.) </p>
<p>(Edit2:) <br>
(deleted; was not good) <br>
<strong>Now hopefully better:</strong> <br>
What you actually need has little do do with randomizing. Depending on the preferred words it is nown as a chapter of mathematical graph-theory, or more pragmatically - often needed - the task to schedule (sine-die) the first set of matchdays for a 20-league. In your case the participants are just not expected to fight one another. </p>
<p>Theory: <a href="http://www.mathaware.org/mam/2010/essays/FroncekTournament.pdf">http://www.mathaware.org/mam/2010/ess...</a> <br>Spreadsheets for the task: <a href="http://www.excelformeln.de/bilder/Liga-Spielplan.zip">http://www.excelformeln.de/bilder/Lig...</a> <br>
(German; no understanding of the language needed. Simply replace the names.) <br>(Author's page in that site: <a href="http://www.excelformeln.de/uberuns.html?umenuzahl=14&autor=1">http://www.excelformeln.de/uberuns.ht...</a>) </p>
<p>If randomization shall be included you may first of all randomize the order of names (and leave it at that then) or randomize the order of the pairings you want to apply them in (or both). </p>
<p>The linked sheet is in .xls and contains relics of VBA though there is no active code at all. I made an .ods of it without the macro modules ("hard work") and it still did its duty. Of cours you may simply reject permission for macros.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136286#post-id-136286@shoegato: Sorry. When I saved the demo it still contained an empty BASIC module. Therefore you are prompted for permission for "macros" on opening. Simply reject this. No functionality in the sheet is based on "macros".Sat, 28 Oct 2017 13:27:18 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=136286#post-id-136286Answer by WalterBarrett for <p>So far I have the following to find a random cell value within the column range I got.</p>
<pre><code>=INDEX(Sheet1.A2:A21, RANDBETWEEN(2,21))
</code></pre>
<p>The problem is that I haven't been able to figure out how to check for repetitions.</p>
<p>I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit (P(n,r)=P(21,2)
=21!(21−2)!
= 420). Ideally I would do this on the rows and columns following (ex. B2:B21) and would generate 20 more column ranges to cover all permutations. I might be wrong about the number of columns necessary.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?answer=191278#post-id-191278You may also have noticed that there are more than one experienced contributors here who are unhappy with things as they are.Tue, 23 Apr 2019 13:40:49 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?answer=191278#post-id-191278Answer by WalterBarrett for <p>So far I have the following to find a random cell value within the column range I got.</p>
<pre><code>=INDEX(Sheet1.A2:A21, RANDBETWEEN(2,21))
</code></pre>
<p>The problem is that I haven't been able to figure out how to check for repetitions.</p>
<p>I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit (P(n,r)=P(21,2)
=21!(21−2)!
= 420). Ideally I would do this on the rows and columns following (ex. B2:B21) and would generate 20 more column ranges to cover all permutations. I might be wrong about the number of columns necessary.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?answer=191040#post-id-191040To generate the unique random numbers in Excel, you need to use two formulas. 1． Suppose you need to generate random numbers without duplicates into column A and column B, now select cell E1, and type this formula =RAND(), then press Enter key. Further check this [free citation generator](https://kingcitation.com/) for more tips.Sat, 20 Apr 2019 06:37:18 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?answer=191040#post-id-191040Comment by Lupp for <p>To generate the unique random numbers in Excel, you need to use two formulas. 1． Suppose you need to generate random numbers without duplicates into column A and column B, now select cell E1, and type this formula =RAND(), then press Enter key. Further check this <a href="https://kingcitation.com/">free citation generator</a> for more tips.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=191262#post-id-191262-1- Quoting the OQ: "I have a list of names from A2:A21 and I want to randomize them so that they do not repeat and they always give a new ordering--I'm using this to create different student pairs daily as far as permutations permit "
This can tell us that the wording of tzhe subject was misleading. I tried to help with the actual problem, and this is what my comments are about.
-2- Don't misuse this askbot sikte to post spam. I will edit your answer to remove the spam. If you insist in spamming I will delete your posts without further notice.Tue, 23 Apr 2019 10:50:22 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=191262#post-id-191262Comment by Lupp for <p>To generate the unique random numbers in Excel, you need to use two formulas. 1． Suppose you need to generate random numbers without duplicates into column A and column B, now select cell E1, and type this formula =RAND(), then press Enter key. Further check this <a href="https://kingcitation.com/">free citation generator</a> for more tips.</p>
https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=191177#post-id-191177(Why "Excel"?)
As I see it now, the original questioner had an even number of items and wanted a series of partitions in pairs of different ones of these items where also none of the pairs repeated.
To achieve this he doesn't only need permutations of his original list without any fixed-point, but also a way to select and generate a series of these permutations making sure that no item goes to a place where it already was in one of the previous permutations.
This means: I now read the original question as one equivalent to the problem to create a fixture-list for a soccer-league of 20 teams. We should use one of the well proven programs for the task, and reduce the random aspect to the permutation of the programs per match-day if we want a kind of surprise-effect.
See also: Graph Theory.Mon, 22 Apr 2019 11:43:37 +0200https://ask.libreoffice.org/en/question/136185/how-to-generate-random-non-repeating-cells-from-a-starting-range/?comment=191177#post-id-191177