display the numerical ranking of a row of numbers in another row

[rustydan]

I want to display the numerical ranking (1,2,3... ) of a row of numbers in
the next row example:

results 45 47 40 53
rank 3 2 4 1

 

[John Bundy]

Use the rank function
=RANK(A1,$A$1:$D$1)