Hi,
Thank you for reading this.
Question:
PERCENTRANK.INC(D:D,D2,4)
Is there a way to reference the array segment of the formula with by referencing another cell? For example, the formula.. "PERCENTRANK.INC(D:D,D2,4)" referring to column D. I'm wanting to figure out a way for the formula to reference different columns based upon a cell value. So it will switch to column E, F, or G.
I have a fairly mega spreadsheet, and will run into memory limitations and need to limit the amount of formulas, therefore, I hope to minimize the amount of formulas by being able to reference columns I choose. I don't want to have to %rank each column, but just pick and choose the columns I need to % rank overtime.
Does this make sense? Thank you.
https://www.dropbox.com/home?preview=2015-05-21+PERCENTRANK.INC+formula.xlsx
Thank you for reading this.
Question:
PERCENTRANK.INC(D:D,D2,4)
Is there a way to reference the array segment of the formula with by referencing another cell? For example, the formula.. "PERCENTRANK.INC(D:D,D2,4)" referring to column D. I'm wanting to figure out a way for the formula to reference different columns based upon a cell value. So it will switch to column E, F, or G.
I have a fairly mega spreadsheet, and will run into memory limitations and need to limit the amount of formulas, therefore, I hope to minimize the amount of formulas by being able to reference columns I choose. I don't want to have to %rank each column, but just pick and choose the columns I need to % rank overtime.
Does this make sense? Thank you.
https://www.dropbox.com/home?preview=2015-05-21+PERCENTRANK.INC+formula.xlsx