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

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

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

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

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"rustydan" wrote:

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