When I use the INDIRECT command, as in the following example,

PERCENTILE(INDIRECT("$FM"&$Y140):$FM140, FN$1)

it works fine until I insert a new column anywhere before the column
containing the IDIRECT command. If I do that, the first parameter in the
command changes,

PERCENTILE(INDIRECT("$FL"&$Y140):$FM140, FN$1)

notwithstanding the $ that I had put there to prevent its changing. Is
there any way to avoid that?
--
Delaware Mac