Thread: Insert cell text every 5 rows in a column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Excelenator Excelenator is offline
external usenet poster
  
Posts: 1
Default Insert cell text every 5 rows in a column

Place a 1 in the first cell and a 2 in the second cell. In the third
cell down place this formula and then copy it down as far as you want
to go.

=IF(ISNUMBER(A2),IF(MOD(A2,5)=0,"TEXT",A2+1),A1+1)

If you need actual values you can alwasy copy and paste values after
this is done.


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=568428

Reply With QuoteReply With Quote