LinkBack URL
About LinkBacks
Hi. I want to insert the same data in a cell every 28 rows. I can see a few ways of doing it involving IF OFFSET DAY formulae.
What's the simplest please ?
K
Hi. I want to insert the same data in a cell every 28 rows. I can see a few ways of doing it involving IF OFFSET DAY formulae.
What's the simplest please ?
K
This can get quite complicated.
I normally use the Mod Function
Paste this into row 1 and fill down,
Formula:
=IF(MOD(ROW(),28)=0,1,"")
Last edited by mehmetcik; 12-02-2016 at 12:12 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
The formula at Post 2 will only produce a "1" on rows 28, 56, etc. for amore flexible formula that will put a 1 in the first cell it is pasted in, and every 28th row thereafter is this:
=IF(MOD(ROW(C5)-ROW($C$5),28)=0,1,"")
Substitute C5 and $C$5 for whatever cell you want to start in.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Many thanks all, this has helped
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks