break points using formula

[sandeephg]

Hi All,

Could some help me on putting break point on every 7th line in attached sheet?

I do have larger data to work on hence I am looking for any formula which gives result as “B” in Column B on every 7th after by after.
Any feed back is welcome

Thanks in advance

Sandy -;@

[DonkeyOte]

Assuming the last B in your sample file should in fact have appeared in B22 and not B21 then

B2: =IF(MOD(ROWS(B$2:B2)-1,7)=6,"B","")
copied down