|The reason you can only find macro based solutions is because it can only be done with macros. Formula can only return values, they can't perform actions.|
The code found at this site was written to look at Column A, but I modified it to look at Column R. I've also included the instructions on how to use to macro from this site and included them below. You don't need your TRUE FALSE column since the macro can use the changes in Column R to determine where to insert the rows.
Dim r As Long, mcol As String, i As Long
' find last used cell in Column R
r = Cells(Rows.Count, "R").End(xlUp).Row
' get value of last used cell in column R
mcol = Cells(r, "R").Value
' insert rows by looping from bottom
For i = r To 2 Step -1
If Cells(i, "R").Value <> mcol Then
mcol = Cells(i, "R").Value
Rows(i + 1).Insert
How to use this code:
Go to Developer Ribbon...Visual Basic (Alt+F11)
A new window will open.
Go to Insert>Module
Copy and paste the above code in the pane that opens.
Close the window.
Back in your Excel worksheet.
Go to Developer Ribbon...Macro's (Alt+F8)
A new small window will open.
Double click "InsertRows" to see the result of the code.
If something is still unclear then post back.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.