Excel random function
up vote
-1
down vote
favorite
I have a Excel problem:
- I have 9 different numbers or letters (from 1 to 9 or a to i).
- For each number I need to assign 1 number from remaining numbers (same number can not be assigned to itself for example 1 can not be assigned to 1).
- Second requirement is that each number has to be used only 1 time.
I already tried 1 example from here with modification:
=IF(A1=A1, RANDBETWEEN(2, 9), RANDBETWEEN(2, 9))
Unfortunately this does not work for me and I suppose 1 more IF needs to be used.
Can anyone help me with Excel code?
microsoft-excel
edited Nov 21 at 10:28
Albin
2,2931129
asked Nov 21 at 8:50
Jan Jesenius
61
|
show 6 more comments
up vote
-1
down vote
favorite
I have a Excel problem:
- I have 9 different numbers or letters (from 1 to 9 or a to i).
- For each number I need to assign 1 number from remaining numbers (same number can not be assigned to itself for example 1 can not be assigned to 1).
- Second requirement is that each number has to be used only 1 time.
I already tried 1 example from here with modification:
=IF(A1=A1, RANDBETWEEN(2, 9), RANDBETWEEN(2, 9))
Unfortunately this does not work for me and I suppose 1 more IF needs to be used.
Can anyone help me with Excel code?
microsoft-excel
edited Nov 21 at 10:28
Albin
2,2931129
asked Nov 21 at 8:50
Jan Jesenius
61
What have you tried so far? Please update your question with your worked examples. Super User is not a script writing service. superuser.com/help/on-topic
– spikey_richie
Nov 21 at 8:52
I tryied only randombetween function but I am not able to use it with if function.
– Jan Jesenius
Nov 21 at 8:56
I'm voting to close this question as off-topic because questions must demonstrate a reasonable amount of research & understanding of the problem being solved. Please edit to either a) clearly describe your problem and the research done so far to solve it or b) include attempted solutions plus why they didn't work. In either case, be sure your expected results are clearly presented.
– Tetsujin
Nov 21 at 8:58
1
what is not clear from explanation of problem? I am just unable to solve it by myself.
– Jan Jesenius
Nov 21 at 8:59
1
Not homework (coursework). I have 9 users. Each user needs to draw another user for christmas gift. Thats all :-).
– Jan Jesenius
Nov 21 at 9:29
|
show 6 more comments
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have a Excel problem:
- I have 9 different numbers or letters (from 1 to 9 or a to i).
- For each number I need to assign 1 number from remaining numbers (same number can not be assigned to itself for example 1 can not be assigned to 1).
- Second requirement is that each number has to be used only 1 time.
I already tried 1 example from here with modification:
=IF(A1=A1, RANDBETWEEN(2, 9), RANDBETWEEN(2, 9))
Unfortunately this does not work for me and I suppose 1 more IF needs to be used.
Can anyone help me with Excel code?
microsoft-excel
edited Nov 21 at 10:28
Albin
2,2931129
asked Nov 21 at 8:50
Jan Jesenius
61
I have a Excel problem:
- I have 9 different numbers or letters (from 1 to 9 or a to i).
- For each number I need to assign 1 number from remaining numbers (same number can not be assigned to itself for example 1 can not be assigned to 1).
- Second requirement is that each number has to be used only 1 time.
I already tried 1 example from here with modification:
=IF(A1=A1, RANDBETWEEN(2, 9), RANDBETWEEN(2, 9))
Unfortunately this does not work for me and I suppose 1 more IF needs to be used.
Can anyone help me with Excel code?
microsoft-excel
microsoft-excel
edited Nov 21 at 10:28
Albin
2,2931129
asked Nov 21 at 8:50
Jan Jesenius
61
edited Nov 21 at 10:28
Albin
2,2931129
asked Nov 21 at 8:50
Jan Jesenius
61
edited Nov 21 at 10:28
Albin
2,2931129
edited Nov 21 at 10:28
Albin
2,2931129
edited Nov 21 at 10:28
Albin
2,2931129
2,2931129
asked Nov 21 at 8:50
Jan Jesenius
61
asked Nov 21 at 8:50
Jan Jesenius
61
asked Nov 21 at 8:50
Jan Jesenius
61
61
What have you tried so far? Please update your question with your worked examples. Super User is not a script writing service. superuser.com/help/on-topic
– spikey_richie
Nov 21 at 8:52
I tryied only randombetween function but I am not able to use it with if function.
– Jan Jesenius
Nov 21 at 8:56
I'm voting to close this question as off-topic because questions must demonstrate a reasonable amount of research & understanding of the problem being solved. Please edit to either a) clearly describe your problem and the research done so far to solve it or b) include attempted solutions plus why they didn't work. In either case, be sure your expected results are clearly presented.
– Tetsujin
Nov 21 at 8:58
1
what is not clear from explanation of problem? I am just unable to solve it by myself.
– Jan Jesenius
Nov 21 at 8:59
1
Not homework (coursework). I have 9 users. Each user needs to draw another user for christmas gift. Thats all :-).
– Jan Jesenius
Nov 21 at 9:29
|
show 6 more comments
What have you tried so far? Please update your question with your worked examples. Super User is not a script writing service. superuser.com/help/on-topic
– spikey_richie
Nov 21 at 8:52
I tryied only randombetween function but I am not able to use it with if function.
– Jan Jesenius
Nov 21 at 8:56
I'm voting to close this question as off-topic because questions must demonstrate a reasonable amount of research & understanding of the problem being solved. Please edit to either a) clearly describe your problem and the research done so far to solve it or b) include attempted solutions plus why they didn't work. In either case, be sure your expected results are clearly presented.
– Tetsujin
Nov 21 at 8:58
1
what is not clear from explanation of problem? I am just unable to solve it by myself.
– Jan Jesenius
Nov 21 at 8:59
1
Not homework (coursework). I have 9 users. Each user needs to draw another user for christmas gift. Thats all :-).
– Jan Jesenius
Nov 21 at 9:29
What have you tried so far? Please update your question with your worked examples. Super User is not a script writing service. superuser.com/help/on-topic
– spikey_richie
Nov 21 at 8:52
What have you tried so far? Please update your question with your worked examples. Super User is not a script writing service. superuser.com/help/on-topic
– spikey_richie
Nov 21 at 8:52
I tryied only randombetween function but I am not able to use it with if function.
– Jan Jesenius
Nov 21 at 8:56
I tryied only randombetween function but I am not able to use it with if function.
– Jan Jesenius
Nov 21 at 8:56
I'm voting to close this question as off-topic because questions must demonstrate a reasonable amount of research & understanding of the problem being solved. Please edit to either a) clearly describe your problem and the research done so far to solve it or b) include attempted solutions plus why they didn't work. In either case, be sure your expected results are clearly presented.
– Tetsujin
Nov 21 at 8:58
I'm voting to close this question as off-topic because questions must demonstrate a reasonable amount of research & understanding of the problem being solved. Please edit to either a) clearly describe your problem and the research done so far to solve it or b) include attempted solutions plus why they didn't work. In either case, be sure your expected results are clearly presented.
– Tetsujin
Nov 21 at 8:58
1
1
what is not clear from explanation of problem? I am just unable to solve it by myself.
– Jan Jesenius
Nov 21 at 8:59
what is not clear from explanation of problem? I am just unable to solve it by myself.
– Jan Jesenius
Nov 21 at 8:59
1
1
Not homework (coursework). I have 9 users. Each user needs to draw another user for christmas gift. Thats all :-).
– Jan Jesenius
Nov 21 at 9:29
Not homework (coursework). I have 9 users. Each user needs to draw another user for christmas gift. Thats all :-).
– Jan Jesenius
Nov 21 at 9:29
|
show 6 more comments
1 Answer
1
active
oldest
votes
up vote
0
down vote
As there is no solution from anybody, I am sending one which works for me.
Maybe someone will need it in future.
However I am disappointed from answers to my question on this forum...
Solution
edited Nov 21 at 13:48
Aulis Ronkainen
6051714
answered Nov 21 at 13:10
Jan Jesenius
61
+1 Bravo for working it out, you didn't need out help after all :) but -1, you need to understand we're not here to work things out for you, you need to bring more to the table. I hope this experience hasn't put you off using SU again in the future.
– spikey_richie
Nov 21 at 14:16
Interesting because I found similar question here and below were direct answers without commnets. This is the reason why I am disappointed.
– Jan Jesenius
Nov 22 at 6:01
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
As there is no solution from anybody, I am sending one which works for me.
Maybe someone will need it in future.
However I am disappointed from answers to my question on this forum...
Solution
edited Nov 21 at 13:48
Aulis Ronkainen
6051714
answered Nov 21 at 13:10
Jan Jesenius
61
+1 Bravo for working it out, you didn't need out help after all :) but -1, you need to understand we're not here to work things out for you, you need to bring more to the table. I hope this experience hasn't put you off using SU again in the future.
– spikey_richie
Nov 21 at 14:16
Interesting because I found similar question here and below were direct answers without commnets. This is the reason why I am disappointed.
– Jan Jesenius
Nov 22 at 6:01
add a comment |
up vote
0
down vote
As there is no solution from anybody, I am sending one which works for me.
Maybe someone will need it in future.
However I am disappointed from answers to my question on this forum...
Solution
edited Nov 21 at 13:48
Aulis Ronkainen
6051714
answered Nov 21 at 13:10
Jan Jesenius
61
+1 Bravo for working it out, you didn't need out help after all :) but -1, you need to understand we're not here to work things out for you, you need to bring more to the table. I hope this experience hasn't put you off using SU again in the future.
– spikey_richie
Nov 21 at 14:16
Interesting because I found similar question here and below were direct answers without commnets. This is the reason why I am disappointed.
– Jan Jesenius
Nov 22 at 6:01
add a comment |
up vote
0
down vote
up vote
0
down vote
As there is no solution from anybody, I am sending one which works for me.
Maybe someone will need it in future.
However I am disappointed from answers to my question on this forum...
Solution
edited Nov 21 at 13:48
Aulis Ronkainen
6051714
answered Nov 21 at 13:10
Jan Jesenius
61
As there is no solution from anybody, I am sending one which works for me.
Maybe someone will need it in future.
However I am disappointed from answers to my question on this forum...
Solution
edited Nov 21 at 13:48
Aulis Ronkainen
6051714
answered Nov 21 at 13:10
Jan Jesenius
61
edited Nov 21 at 13:48
Aulis Ronkainen
6051714
edited Nov 21 at 13:48
Aulis Ronkainen
6051714
edited Nov 21 at 13:48
Aulis Ronkainen
6051714
6051714
answered Nov 21 at 13:10
Jan Jesenius
61
answered Nov 21 at 13:10
Jan Jesenius
61
answered Nov 21 at 13:10
Jan Jesenius
61
61
+1 Bravo for working it out, you didn't need out help after all :) but -1, you need to understand we're not here to work things out for you, you need to bring more to the table. I hope this experience hasn't put you off using SU again in the future.
– spikey_richie
Nov 21 at 14:16
Interesting because I found similar question here and below were direct answers without commnets. This is the reason why I am disappointed.
– Jan Jesenius
Nov 22 at 6:01
add a comment |
+1 Bravo for working it out, you didn't need out help after all :) but -1, you need to understand we're not here to work things out for you, you need to bring more to the table. I hope this experience hasn't put you off using SU again in the future.
– spikey_richie
Nov 21 at 14:16
Interesting because I found similar question here and below were direct answers without commnets. This is the reason why I am disappointed.
– Jan Jesenius
Nov 22 at 6:01
+1 Bravo for working it out, you didn't need out help after all :) but -1, you need to understand we're not here to work things out for you, you need to bring more to the table. I hope this experience hasn't put you off using SU again in the future.
– spikey_richie
Nov 21 at 14:16
+1 Bravo for working it out, you didn't need out help after all :) but -1, you need to understand we're not here to work things out for you, you need to bring more to the table. I hope this experience hasn't put you off using SU again in the future.
– spikey_richie
Nov 21 at 14:16
Interesting because I found similar question here and below were direct answers without commnets. This is the reason why I am disappointed.
– Jan Jesenius
Nov 22 at 6:01
Interesting because I found similar question here and below were direct answers without commnets. This is the reason why I am disappointed.
– Jan Jesenius
Nov 22 at 6:01
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377210%2fexcel-random-function%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What have you tried so far? Please update your question with your worked examples. Super User is not a script writing service. superuser.com/help/on-topic
– spikey_richie
Nov 21 at 8:52
I tryied only randombetween function but I am not able to use it with if function.
– Jan Jesenius
Nov 21 at 8:56
I'm voting to close this question as off-topic because questions must demonstrate a reasonable amount of research & understanding of the problem being solved. Please edit to either a) clearly describe your problem and the research done so far to solve it or b) include attempted solutions plus why they didn't work. In either case, be sure your expected results are clearly presented.
– Tetsujin
Nov 21 at 8:58
1
what is not clear from explanation of problem? I am just unable to solve it by myself.
– Jan Jesenius
Nov 21 at 8:59
1
Not homework (coursework). I have 9 users. Each user needs to draw another user for christmas gift. Thats all :-).
– Jan Jesenius
Nov 21 at 9:29