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,2951029
asked Nov 21 at 8:50
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
|
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,2951029
asked Nov 21 at 8:50
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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,2951029
asked Nov 21 at 8:50
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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,2951029
asked Nov 21 at 8:50
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 21 at 10:28
Albin
2,2951029
asked Nov 21 at 8:50
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 21 at 10:28
Albin
2,2951029
edited Nov 21 at 10:28
Albin
2,2951029
edited Nov 21 at 10:28
Albin
2,2951029
2,2951029
asked Nov 21 at 8:50
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 21 at 8:50
Jan Jesenius
61
asked Nov 21 at 8:50
Jan Jesenius
61
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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
6151514
answered Nov 21 at 13:10
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
+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
6151514
answered Nov 21 at 13:10
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
+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
6151514
answered Nov 21 at 13:10
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
+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
6151514
answered Nov 21 at 13:10
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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
6151514
answered Nov 21 at 13:10
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 21 at 13:48
Aulis Ronkainen
6151514
edited Nov 21 at 13:48
Aulis Ronkainen
6151514
edited Nov 21 at 13:48
Aulis Ronkainen
6151514
6151514
answered Nov 21 at 13:10
Jan Jesenius
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered Nov 21 at 13:10
Jan Jesenius
61
answered Nov 21 at 13:10
Jan Jesenius
61
61
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Jan Jesenius is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
+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 |
Jan Jesenius is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Jan Jesenius is a new contributor. Be nice, and check out our Code of Conduct.
Jan Jesenius is a new contributor. Be nice, and check out our Code of Conduct.
Jan Jesenius is a new contributor. Be nice, and check out our Code of Conduct.
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