I would like to copy one cell formula to another but i would like the constant to remain intact. When i pull it over to another cell there is an incremental effect.
from:
=SUM(LEN(B9:B300)-LEN(SUBSTITUTE(B9:B300,B4&","&D8,"")))/(LEN(B4&","&D8))
to
=SUM(LEN(B9:B300)-LEN(SUBSTITUTE(B9:B300,B5&","&D8,"")))/(LEN(B5&","&D8))
But i want it to be either
=SUM(LEN(B9:B300)-LEN(SUBSTITUTE(B9:B300,B4&","&D8,"")))/(LEN(B4&","&D8))
or better still simple increment just value
=SUM(LEN(B9:B300)-LEN(SUBSTITUTE(B9:B300,B4&","&D9,"")))/(LEN(B4&","&D9))
thanks
Bookmarks