I use an existing spreadsheet every month to calculate salespeoples sales.
With turn over the number of sales people changes every month. Which means
the rows I am trying to rank change every month. I takes me hours to change
=RANK(C6,C6:C44) to say =RANK(C6, C6:C50) on every cell since the copy paste
function distorts the formula. Is there any way I can say sort all of row C
no matter how much data is there? Please help....

Thank you in advance!