Results 1 to 7 of 7

Change array to include new cells

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2009
    Location
    Arlington, VA
    MS-Off Ver
    Excel 2007
    Posts
    80

    Change array to include new cells

    I am having a ton of trouble with this. I am trying to add a single text row in between existing data. I have tried multiple loops to try to place an array into Column G, but I cannot figure it out. Is there some coding that will produce the sort of result below in column G?

    Col E	Col F	Col G
    		
    a	1	a
    a	1	a
    a	1	a
    b	0	SUMMARY
    b	0	b
    b	0	b
    b	0	b
    b	0	b
    c	1	b
    c	1	SUMMARY
    c	1	c
    c	1	c
    d	0	c
    e	1	c
    e	1	SUMMARY
    f	0	d
    f	0	SUMMARY
    		e
    		e
    		SUMMARY
    		f
    		f
    		SUMMARY
    Last edited by nsorden; 08-31-2009 at 02:26 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1