# (URGENT) NEW CHALLENGE AGAIN: HOW TO PRODUCE COMBINATIONS OFDIFFERENT RANDOM NUMBERS AND DO NOT F

  • Thread starter Thread starter rjmachado
  • Start date Start date
R

rjmachado

# NEW CHALLENGE AGAIN: HOW TO PRODUCE COMBINATIONS OF DIFFERENT RANDOM
NUMBERS AND DO NOT FULLY SINGLE REPEATABLE AND WITH THE NUMBERS IN
CRESCENT ORDER IN EXCEL 2003???

THIS SOLUTION ABOVE IS GREAT BUT DON'T HAVE THE 5+2 RANDOM NUMBERS
AUTOMATICALLY SORTED IN CRESCENT ORDER.

CHECK THIS FILE:
http://cjoint.com/?kmqbqKuGZL

THIS WORKS BUT THE NUMBERS ARE NOT SORTED AND I NEED SORT THEM IN
CRESCENT ORDER IN A AUTOMATIC WAY (EX: {1,5,7,14,25, 1, 2} INSTEAD OF
{5,1,7,25,14, 2, 1})

IF YOU CAN HELP, PLEASE HELP ME. I WILL BE GRATEFUL FOR YOUR HELP.
THANKS FOR PRIESTING ATTENTION.
 
Hi,

Since it looks like you are willing to hide stuff. In the sampe spreadsheet
I entered
=SMALL($G$2:$K$2,COLUMN(A1))
below the first number, in G2 and copied this to the right to column K. You
could then do this same thing for the last two.
 
# NEW CHALLENGE AGAIN: HOW TO PRODUCE COMBINATIONS OF DIFFERENT RANDOM
NUMBERS  AND DO NOT FULLY SINGLE REPEATABLE AND WITH THE NUMBERS IN
CRESCENT ORDER IN EXCEL 2003???

THIS SOLUTION ABOVE IS GREAT BUT DON'T HAVE THE 5+2 RANDOM NUMBERS
AUTOMATICALLY SORTED IN CRESCENT ORDER.

CHECK THIS FILE:http://cjoint.com/?kmqbqKuGZL

THIS WORKS BUT THE NUMBERS ARE NOT SORTED AND I NEED SORT THEM IN
CRESCENT ORDER IN A AUTOMATIC WAY (EX: {1,5,7,14,25, 1, 2} INSTEAD OF
{5,1,7,25,14, 2, 1})

IF YOU CAN HELP, PLEASE HELP ME. I WILL BE GRATEFUL FOR YOUR HELP.
THANKS FOR PRIESTING ATTENTION.
Click to expand...

thanks for everyone who takes this challenge, but i found the solution
in the "MINOR()" function. I'm grateful for your help! :-)
 
# NEW CHALLENGE AGAIN: HOW TO PRODUCE COMBINATIONS OF DIFFERENT RANDOM
NUMBERS  AND DO NOT FULLY SINGLE REPEATABLE AND WITH THE NUMBERS IN
CRESCENT ORDER IN EXCEL 2003???

THIS SOLUTION ABOVE IS GREAT BUT DON'T HAVE THE 5+2 RANDOM NUMBERS
AUTOMATICALLY SORTED IN CRESCENT ORDER.

CHECK THIS FILE:http://cjoint.com/?kmqbqKuGZL

THIS WORKS BUT THE NUMBERS ARE NOT SORTED AND I NEED SORT THEM IN
CRESCENT ORDER IN A AUTOMATIC WAY (EX: {1,5,7,14,25, 1, 2} INSTEAD OF
{5,1,7,25,14, 2, 1})

IF YOU CAN HELP, PLEASE HELP ME. I WILL BE GRATEFUL FOR YOUR HELP.
THANKS FOR PRIESTING ATTENTION.
Click to expand...

thanks for everyone who takes this challenge, but i found the solution
in the "MINOR()" function. I'm grateful for your help! :-)
 
Next time you might want to avoid all caps and the urgent part,
I am sure you will get less answers just by having that.

It's better to be polite and not to expect some sort of urgency,
no posts are more urgent than others.

--


Regards,


Peo Sjoblom

# NEW CHALLENGE AGAIN: HOW TO PRODUCE COMBINATIONS OF DIFFERENT RANDOM
NUMBERS AND DO NOT FULLY SINGLE REPEATABLE AND WITH THE NUMBERS IN
CRESCENT ORDER IN EXCEL 2003???

THIS SOLUTION ABOVE IS GREAT BUT DON'T HAVE THE 5+2 RANDOM NUMBERS
AUTOMATICALLY SORTED IN CRESCENT ORDER.

CHECK THIS FILE:http://cjoint.com/?kmqbqKuGZL

THIS WORKS BUT THE NUMBERS ARE NOT SORTED AND I NEED SORT THEM IN
CRESCENT ORDER IN A AUTOMATIC WAY (EX: {1,5,7,14,25, 1, 2} INSTEAD OF
{5,1,7,25,14, 2, 1})

IF YOU CAN HELP, PLEASE HELP ME. I WILL BE GRATEFUL FOR YOUR HELP.
THANKS FOR PRIESTING ATTENTION.
Click to expand...

thanks for everyone who takes this challenge, but i found the solution
in the "MINOR()" function. I'm grateful for your help! :-)
 
u can also use small function

in your eg. rand number are in cell G2:K2

in G3 =SMALL(G2:K2,1)
in H3 =SMALL(G2:K2,2)................
 
Hi,

Well apparently you have an Add-in because no Excel version I know of has a
function called MINOR().

And I second Peo comment. You are yelling when you type in all capitals and
that is hard to read and somewhat annoying.
 
Back
Top