Changed Data array

  • Thread starter Thread starter Scottmk
  • Start date Start date
S

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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PERCENTRANK in array formula: strange behavior 4
Using Named Range within an Array Formula 2
Formula changes as new data is entered... 4
Copy Array to Array, how to and should I? 13
Excel Wildcard in Excel array formula 0
Percentrank 1
array transpose for dynamic data without macros 7
Randomly Re-arrange Entries in an array. 1

Back
Top