I am trying to create a workbook where each individual player has their own sheet that keeps track of their highest scores over a series of games. I have created a column that has a formula for ranking that is working well. What I would like is for the highest ranking score and the name of that particular game to automatically transfer from the player's individual sheets on to a summary sheet of all the player's highest scores. I thought it would be easy, something like (if rank =1, then put this game name and this score on the front page) but it isn't for me! Does anyone have any ideas how to go about this? Many thanks!