Have you looked at the RANK function in help?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bruno Coelho" wrote in message
...
Hi, I'm having problems with auto numbers, i don't know if is possible to
do
that. I want to do a function that checks the points in column B and the
biggest point is 1st. For example, i have in column A the RESULTS, Column
B
POINTS. in line 1 column B i have 50 points, and line2 columnB 45 points,
etc..., and the function will check the two lines to see who have the
biggest
points, in this case the function will put line1 - 1st and line2 - 2nd.
Any sugestion!

Thanks