formula for numeric order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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 said:
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
Click to expand...
with excel for work purposes at times.
 
Back
Top