Dude that is awesome!!!
Thanks!!

I got one more for ya.
What if the number of rows in column A changes? Let's say today there
are 8 people on the list and 4 have ranks.. Tommorow there will be 20
and 15 of them will have ranks, and so on.


--
matthewst
------------------------------------------------------------------------
matthewst's Profile: http://www.excelforum.com/member.php...o&userid=20340
View this thread: http://www.excelforum.com/showthread...hreadid=483610