How do you copy RANK w/o it changing the range?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you copy RANK w/o it changing the range when you are copying multiple
cells on a worksheet in Excel 2003?
 
That depends on which ranges. You could change the formula to a string
prior to the copy by inserting a single quote before the = sign, then copy,
paste, and delete the quote mark. Or, possibly, you could use absolute
range references on one or more of the range references (that means A1:A100
should look like $A$1:$A$100)

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Rank – multiple ranges from different worksheets 3
Scrabble Value calculation for Welsh words 0
Ranking to include new list 2
Rank Formula 1
Rank - Change the Rank of a Tie 1
RANK - Remove repeated ranks for sorting 9
Ranking Q 1
can you rank more than 7 items? how? 4

Back
Top