Hi,
If I have a custom value that I enter in cell A1, I want row B to populate the total number of values in a sequential list, every third row.
A1= 3
B1=1
B2=
B3=
B4=2
B5=
B6=
B7=3
B8=
B9=
etc....
Thank you,
Danny
Hi,
If I have a custom value that I enter in cell A1, I want row B to populate the total number of values in a sequential list, every third row.
A1= 3
B1=1
B2=
B3=
B4=2
B5=
B6=
B7=3
B8=
B9=
etc....
Thank you,
Danny
If you start off with manual seed entry of 1 on B1, you can put this in B4 and copy down as needed...
=IF(MOD(ROW(),3)=1,MAX($B$1:B3)+1,"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks