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

Qadi

Junior Member

Posts: 3

Quote:

Originally Posted by Mazzaropi

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste to next empty cell in named range of cells	Sully	Excel Discussion (Misc queries)	3	March 4th 10 05:23 PM
sum of cells until reach empty cell	phsdave	Excel Worksheet Functions	4	January 24th 10 11:15 AM
<ASK How to add columm more than the default columm IV	johannes	Excel Discussion (Misc queries)	3	September 16th 08 06:03 PM
count non empty cells if other cell has certain value	Nico	Excel Discussion (Misc queries)	5	May 18th 06 10:40 AM
Excel - Autom. Filter "Empty / Non Empty cells" should come first	Rom	Excel Discussion (Misc queries)	0	August 10th 05 04:32 PM

All times are GMT +1. The time now is 09:19 AM.

Menu

About Us