yes, that worked perfectly, thanks Richard!

Only issue is you can't carry over the formula to the next cell and it adjusts to the next cell, you have to manually type the next cell. "C7" remains C7 when copied into C8. Did it manually, but would like it to change based on inseerting and deleting lines. Thanks for your help.