I want to enter random numbers in 3 different cells, (2 of which may be the same number.)
Then I want these 3 numbers to appear again in 3 different cells, but in descending order.
I want this to happen automatically as I change the random numbers.
I have managed to do this when all 3 numbers are different, but not when 2 of them are the same.
Thank you

Daniel,

Try =LARGE($J$1:$J$3,1), =LARGE($J$1:$J$3,2), =LARGE($J$1:$J$3,3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Daniel Warren" wrote in message
...
I want to enter random numbers in 3 different cells, (2 of which may be
the same number.)
Then I want these 3 numbers to appear again in 3 different cells, but in
descending order.
I want this to happen automatically as I change the random numbers.
I have managed to do this when all 3 numbers are different, but not when 2
of them are the same.
Thank you

=Large(A1:A3,1)
=Large(A1:A3,2)
=Large(A1:A3,3)

--
Regards,
Tom Ogilvy

Daniel Warren wrote in message
...
I want to enter random numbers in 3 different cells, (2 of which may be
the same number.)
Then I want these 3 numbers to appear again in 3 different cells, but in
descending order.
I want this to happen automatically as I change the random numbers.
I have managed to do this when all 3 numbers are different, but not when 2
of them are the same.
Thank you

Dear Bob
Thank you for your help and such a quick reply
I am not much of an internet user, nor a programmer, but I like to play with excel for work purposes at times
This is the first time I have been driven by my frustration for an answer to find a site like this
I was not familiar with the "large" command and a solution to my problem was driving me nuts
It is wonderful there are people like you willing to help a stranger like myself. Thank yo
Dan

Dan,

Thanks for that, it is much appreciated to know that our efforts are
appreciated.

Regards

Bob

"Daniel Warren" wrote in message
...
Dear Bob,
Thank you for your help and such a quick reply.
I am not much of an internet user, nor a programmer, but I like to play
with excel for work purposes at times.
This is the first time I have been driven by my frustration for an answer
to find a site like this.
I was not familiar with the "large" command and a solution to my problem
was driving me nuts.
It is wonderful there are people like you willing to help a stranger like
myself. Thank you
Dan