Share via

Every nth column

Anonymous
2011-08-01T05:50:46+00:00

I want to enter a value "x" in every nth column starting from column"y"

As an example:

I have years 1 to 10 across columns starting from colunn "D".

Assume I need to start from year 4 and enter a value on a cycle of every 2 years.

Year 4, 6, 8,10

Start year and cycle must be dynamic.

Tahnks/sglxl

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-08-01T08:09:14+00:00

By dynamic I'm going to assume that you want to place the start and stagger in separate cells somewhere and have the formula adjust as per those values.

        

The formula in D2 is,

=IF(AND(COLUMNS($D:D)>=$A$2,NOT(MOD(COLUMNS($D:D)-$A$2,$B$2))),$C$2,"")

... which can be filled right as necessary. It should be able to be filled down as well, but I'm not sure how your own worksheet has the referenced cells laid out.

I've uploaded the sample worksheet here. Look towards File in the upper left for download options.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-08-01T09:28:40+00:00

    Thanks a million that is very good. I would have never thought of working it out this way.

    Cheers/sglxl

    Was this answer helpful?

    0 comments