On sheet 1 & 2, I enter names and scores. On sheet 3, I want to be able to
list the top 10 scores with their names, as well as keep track of how much
money was paid out to them.

"Gaurav" wrote:

Can you elaborate?

"KaKa" wrote in message
...
How do I get excel to transpose the answer from a formula on the first
sheet
and display it on sheet 3?