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