Is this even possible to do in Excel?

On one side I have 10 randomly place numbers. On the other side, I want those randomly placed numbers arranged from highest to lowest. As far as I know, the output of any formula could only be at max, one number. So is there a way to have all ten show up on the other side?