Hopefully this helps

------Colm 1----Colm 2
Score--17.5------17.8
Rank-----1---------1
--------17.6------17.7
-----------2---------2

Each column would be ranked seperately. There would be multiple columns
involved on a given sheet.
Go to the following link--this should give you a better idea of what
I'm looking for. http://www.fromthepressbox.com/20060728dcimasters.htm
The columns would eventually rank up to 60 numbers in a
given column. Also, I would sometimes need to delete and change some
of the column names. When I've done this in the past, it screws up the
ranking formulas. Is there a way around that?

Thanks again for your help.
Gregg


--
Crash1
------------------------------------------------------------------------
Crash1's Profile: http://www.excelforum.com/member.php...o&userid=36727
View this thread: http://www.excelforum.com/showthread...hreadid=564548