Again, you can do this without vba, using normal functions. I'd use
LARGE to rank them in order  in the third column, then INDEX and MATCH
combined to get the names into column  4.

Excel help  should give you what you need on LARGE, and I have an article
which shows how to combine INDEX and MATCH here:

http://www.grbps.com/Excel6.pdf