ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto numbers?? (https://www.excelbanter.com/excel-programming/353792-auto-numbers.html)

Bruno Coelho

Auto numbers??
 
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

Bob Phillips[_6_]

Auto numbers??
 
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





All times are GMT +1. The time now is 08:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com