How to copy the function to the next cell by skipping every two columns?

How to copy the function to the next cell by skipping every two columns?

Thanks
tony

Originally Posted by DonkeyOte

Either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

OFFSET is Volatile but obviously slightly simpler syntax.

Thanks firstly, however I do not paste the next one cell only. For example, if I want to paste to K1 cell, it counts the alpha in column E1:F10. I'm really hopeful you can help me to slove, thanks!