Using RANK Function

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

I need to rank 225 rows of data. Can I use the replace function so
D4:D229 appears in each cell? Thanks for the help.
Skip
 
Skip,

Use $D$4:$D$229 as the range reference in your RANK function, and it won't change when you copy the
formula.

HTH,
Bernie
MS Excel MVP
 

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

Ranking in Excel 8
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Detemine sales order based on plac changes and not sales figures -mathmatic problem to solve 1
using RANK 1
RANK - dont include zeros 5
Ranking without skipping ranks and percentile 3
IF statement with nested SUMPRODUCT? 3
Rank Funtion Question 1

Back
Top