Rank column with changing # of rows

A

Amy

Is there a formula that will Rank even when rows are added and deleted? Currently I am using =RANK(C8,C8:C43) but when I add or delete rows it throws everything off. Please help :)
 
M

Myrna Larson

To modify the formula, you need to tell us what you want to happen to the
formula when you add or delete rows.

Is there a formula that will Rank even when rows are added and deleted?
Click to expand...
Currently I am using =RANK(C8,C8:C43) but when I add or delete rows it throws
everything off. Please help :)
 
Top