| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
Quote:
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.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
|
#3
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste to next empty cell in named range of cells | Excel Discussion (Misc queries) | |||
| sum of cells until reach empty cell | Excel Worksheet Functions | |||
| <ASK How to add columm more than the default columm IV | Excel Discussion (Misc queries) | |||
| count non empty cells if other cell has certain value | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
Linear Mode
