Results 1 to 3 of 3

Need help inserting text into ever 7th (blank) cell.

Threaded View

  1. #1
    Registered User
    Join Date
    08-26-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Need help inserting text into ever 7th (blank) cell.

    I have this list and I am using the following formula =IF(MOD(ROW(),7)=0,"DC/TRANSMITTAL",INDIRECT("B"&ROW()-INT((ROW())/7))) to add DC/TRANSMITTAL into the blank space between PAXGENE and ROYAL BLUE.

    ROYAL BLUE
    SERUM SST
    RED TOP
    PPT PLASMA
    LAVENDER
    PAXGENE

    ROYAL BLUE
    SERUM SST
    RED TOP
    PPT PLASMA
    LAVENDER
    PAXGENE

    ROYAL BLUE
    SERUM SST
    RED TOP
    PPT PLASMA
    PAXGENE
    ROYAL BLUE

    When I use the above formula I get this:
    ROYAL BLUE
    SERUM SST
    RED TOP
    PPT PLASMA
    LAVENDER
    PAXGENE
    DC/TRANSMITTAL
    0
    ROYAL BLUE
    SERUM SST
    RED TOP
    PPT PLASMA
    LAVENDER
    DC/TRANSMITTAL
    PAXGENE
    0
    ROYAL BLUE
    SERUM SST
    RED TOP
    PPT PLASMA

    Is there any way that I can have the 0 not appear when I use this formula.
    Attached Files Attached Files
    Last edited by deenix; 08-26-2011 at 03:24 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