Forum Discussion
Help with repeating Week Numbers
If all you're asking about is the numbers, and assuming your first 1 is in cell A2 (i.e., the heading is in cell A1), then this formula entered into A3 and copied down will repeat numbers for eight rows and then go to the next.
=IF(MOD(ROW(A2)-1,8)=0,A2+1,A2)
If you also want the names of the Crops to repeat on the same cycle, we'll have to come up with a different formula and approach for that. Let us know. And how flexible (or not) do you want that to be? Might you want some kind of randomness in that?
Perhaps the simplest way to do that, if you want to retain the exact sequence, is a simple IF in each line that says something like the following. You'd have to write each formula once, but from there on out it would just cycle through the names
If all you're asking about is the numbers, and assuming your first 1 is in cell A2 (i.e., the heading is in cell A1), then this formula entered into A3 and copied down will repeat numbers for eight rows and then go to the next.
=IF(MOD(ROW(A2)-1,8)=0,A2+1,A2)
If you also want the names of the Crops to repeat on the same cycle, we'll have to come up with a different formula and approach for that. Let us know. And how flexible (or not) do you want that to be? Might you want some kind of randomness in that?
Perhaps the simplest way to do that, if you want to retain the exact sequence, is a simple IF in each line that says something like the following. You'd have to write each formula once, but from there on out it would just cycle through the names
