Your setup is screwed up.

You should (at least try to) set it up like this then it would be very
simple.

.....A...........B..........C...........D......... ....E
Score......17.5......Rank.....17.8........Rank
................17.6......Rank.....17.7........Ran k
................17.9......Rank.....17.5........Ran k

Biff

"Crash1" wrote in
message ...

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