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