But my range is not fixed eg B4 to B10, sometimes B4 to B7

"Eduardo" wrote:

Hi,
If you copy the formula to another cell the range will vary unless you use
the $ signal in front of the Letters or row numbers i.e.
$B$4:$B$10 always will refer to the range B4 to B10 if you copy this formula
will stay as it

"Bluecat" wrote:

Say I want enter a formulae to find a word in range, and when I copy the
formulae to another range size is different.
Please help