ExcelBanter - urgent: add an empty cell for a certain columm each 5 cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - urgent: add an empty cell for a certain columm each 5 cells (https://www.excelbanter.com/excel-discussion-misc-queries/265982-urgent-add-empty-cell-certain-columm-each-5-cells.html)

Qadi

urgent: add an empty cell for a certain columm each 5 cells

Hi..
i want to add an empty cell for a certain column having a data each 5 cells

before :

9286
9156
9334
8859
9319
29136
29633
29660
28143
29838
28508
28809
29106
27176
28807
10413
11408
11178

and i want it to be

9286
9156
9334
8859
9319

29136
29633
29660
28143
29838

28508
28809
29106
27176
28807

10413
11408
11178

Thanks in advance for the help

Mazzaropi

Quote:

Originally Posted by Qadi (Post 959563)

Dear Qadi, Good Afternoon.

Suppose your data is on Colunm A.

Put this formula on B1 -- =IF(MOD(ROW(),6)=0,"",INDIRECT("A"&ROW()-INT((ROW())/6)))

Copy it down.

Qadi

Quote:

Originally Posted by Mazzaropi (Post 959584)

Dear Qadi, Good Afternoon.

Suppose your data is on Colunm A.

Put this formula on B1 -- =IF(MOD(ROW(),6)=0,"",INDIRECT("A"&ROW()-INT((ROW())/6)))

Copy it down.

Yeah ... Thanks. Mazzaropi

All times are GMT +1. The time now is 06:45 AM.