Lock or freeze A portion of a formula

  • Thread starter Thread starter opus234
  • Start date Start date
O

opus234

I want to lock or freeze a portion of a formula when I drag a formula o
copy it Ex. =FREQUENCY(A1:A217,J8) I want to freeze the portio
A1:A217 but I want J8 to chang relative to the location
Thanks in advance
G
 
Take a look at "the difference between absolute and relative references"
in XL help, e.g.:

=FREQUENCY($A$1:$A$217,J8)


However, FREQUENCY is normally an array-entered function with the second
argument an array of bins. You could accomplish the above with

=COUNTIF($A$1:$A$217,"<=" & J8)
 
For moe infomationn on Norman's formula, see Help on Relative and Absolute
cekl references.

Gord Dibben Excel MVP
 
Back
Top