I need to create a list of numbers running down a column in excel. However, I need the list to only change number every 7 rows. Is there a way to do this?
i.e.
1
1
1
1
1
1
1
2
2
2
2
2
2
2
etc...
I need to create a list of numbers running down a column in excel. However, I need the list to only change number every 7 rows. Is there a way to do this?
i.e.
1
1
1
1
1
1
1
2
2
2
2
2
2
2
etc...
Your sample does not change every seven rows - can you please clarify?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If you really mean what you say, here's a way:
Excel 2016 (Windows) 32 bit
B 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 2 9 2 10 2 11 2 12 2 13 2 14 2 15 3 16 2 17 3 18 3 19 3 20 3 21 3 22 4 23 3
Sheet: Sheet1
Excel 2016 (Windows) 32 bit
B 1 1 2 =IF(MOD(ROW()-1,7)=0,A1+1,A1)
Sheet: Sheet1
Awesome thank you!
You’re welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks