Try the option in my response in the other branch. It gives you the point
formula to paste into a startcell of your choice, then a smooth drag across n
fill down all the way to return the desired results in a matter of seconds.
--
Max
Singapore
---
"Michelle" wrote:
Is there a way I can use the formular reference for "-2" and "+2". I have
over a thousand lines. I am trying to avoid manually change the formular for
each rows.