Forum Discussion
erasureutah
Jul 18, 2022Copper Contributor
Auto increment
Hi. I like to think I'm intermediate with Excel. But I am stumped and I have looked all through this forum and even tried to use as many formulas as possible with no luck. If there is already a post,...
HansVogelaar
Jul 18, 2022MVP
You don't show the row numbers and column letters, but let's assume that the purple cells are D8, D22, D36 etc.
The formula could be
=SUMPRODUCT((D8:D1000<>"")*(MOD(ROW(D8:D1000),14)=8))