Using every 3rd rows ??

Copper Contributor

Hello everyone,

this is  probably basic stuff but I really need help with this, if someone can help me.

What I need to make that when I type 1000 that automatically every 3rd rows will go by 3.

Same like I have in attachment.

 

Thank you in advance.

 

3 Replies

@Dragan1967 

 

 

devyadav2008_1-1607147364276.png

 

devyadav2008_2-1607147392707.png

 

 

copy formula of F2 & G3 and paste up to required raw

@Dragan1967 As a variant:

In A4, enter

=IF(ISNUMBER(A1),A1+3,"")

Copy down and across as needed.

Screenshot 2020-12-05 at 07.35.10.png