S Skip Jun 13, 2008 #1 I need to rank 225 rows of data. Can I use the replace function so D4229 appears in each cell? Thanks for the help. Skip
I need to rank 225 rows of data. Can I use the replace function so D4229 appears in each cell? Thanks for the help. Skip
B Bernie Deitrick Jun 13, 2008 #2 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
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
229 appears in each cell? Thanks for the help.229 appears in each cell? Thanks for the help.