Normally when we copy/paste excel function, on paste the cell reference is adjusted for the
context of where we are pasting to.
For example:
Copy : from K3: =RANK(J3,J3:J25)
To: to K4: =RANK(J4,J4:J26)
Well I want my rank to go over the ENTIRE range from J3:J25, not from a relative range of
J(n) :J25, so how do we do this? Using fixed cell references:
Change our rank to:
No comments:
Post a Comment