Using RANK Function

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
 
B

Bernie Deitrick

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
 
Top