Ranking based on values

Hi,

I'm trying to rank a set of individuals based on scores. Specifically, I'm want to find the top three each day. In the attached example, cell B2 would return "D*ck" since he had the highest score that day (cell A2). Cell C2 would return "Sally" since she had the second highest score and cell D2 would return "Jennifer" since she had the third highest score. My goal is to do this for everyday in the time series.

Can anyone help me out with a function that can accomplish this?

Thank you very much for your help.