I hope someone can help me. I am trying to produce a score sheet for up to 20 players. I have player names in column A and their final score in column D. I have then ranked the final score...all well and good. However where i same rank ties it jumps the next number in the sequence.I need to extract player name for all who placed 1st second and third. Bearing in ming that 1 week i may just have 1 1st winner and the next week i may have 3. The extracted player names have to update dynamically. Can anyone think of a solution?