Excel formula: Sequence but only every second Row

[luminya]

Hi,

is it possible to adjust the =SEQUENCE() formula in a way that only every second row is filled?
I already tried =IF(ISEVEN(ROW());SEQUENCE(10,1)). However I receive the #SPILL Error because it would start anew every time the condition is met. Does anyone have an idea on how to approach this?
I would like to find a solution without VBA.

Thank you very much in advance!

 

[JGordon11]

=LET(s,SEQUENCE(10),IF(ISEVEN(s),s,""))

 

[ISY]

=LET(K,SEQUENCE(12,,,0,5),IF(INT(K)=K,K,""))

 

[ms_excel_recal_or_die]

Hi all,
Another option without LET could be:

= IF( ISEVEN( SEQUENCE( 10 ) ),
SEQUENCE( 10 ),
"" )

The two above, I like.

 

[Fluff]

Hi & welcome to MrExcel.

is it possible to adjust the =SEQUENCE() formula in a way that only every second row is filled?

If you want the alternate rows to be empty, so that you can manually put values in them, then no it's not.

 

[luminya]

Hi all,
thank you very much for all your creative responses! Very helpful!!

 

[Fluff]

Glad we could help & thanks for the feedback.