Changed Data array

[Scottmk]

Hi, on one sheet i have data. Another sheet does a percentrank of tha
data. The question is, when the data array changes in size, is there
way to set it up so I don't have to go through and change the all th
percent rank formulas. The reason I ask, is that the last time I di
this, I swear that it SOMEHOW automatically corrected itself.

Thanks for any help!

 

[Frank Kabel]

Hi
could You post the formula you're using currently