Transferring function results to another sheet

K

KaKa

How do I get excel to transpose the answer from a formula on the first sheet
and display it on sheet 3?
 
D

Dave Peterson

Maybe the worksheet function =transpose()
or edit|copy followed by edit|paste special|Transpose
 
K

KaKa

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
Cell data entering slow! 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Bugs in Office 2019 0
Getting sum of values in another sheet while using condition 5
Lookup or search using the * character 1
Keep original cell formatting when using transpose array formula 1
Newbie Help - IF Yes No Function 0

Top