Insert 3 lines before a specific text/group, subtotal, then total

Re: Insert 3 lines before a specific text/group, subtotal, then total

Hi,

There is two way to make this solution .

1. make the subtotal in excel function. To make the subtotal you need to build the dummy column before making the subtotal.

2. just type 1,2,3 on any one column, copy and paste these three cells to all range.
Select filter on 3 , and insert rows by visible rows.

For creating dummy : you need to use the =counta($c$1:c5) formula , so this will give the dummy column ID's

example like below

1
1
1
1
---
2
2
---
3
3
3
3
3
----
4
---
5
5
5
5
5
---

Hope you understand the idea.

Regards
S.Suresh