Results 1 to 9 of 9

Fill down into merged cells without skipping rows

Threaded View

dancing-shadow Fill down into merged cells... 10-21-2013, 11:50 AM
XOR LX Re: Fill down into merged... 10-21-2013, 12:19 PM
dancing-shadow Re: Fill down into merged... 10-22-2013, 03:11 AM
dancing-shadow Re: Fill down into merged... 11-04-2013, 05:47 AM
Fotis1991 Re: Fill down into merged... 11-04-2013, 06:03 AM
dancing-shadow Re: Fill down into merged... 11-04-2013, 07:37 AM
XOR LX Re: Fill down into merged... 11-04-2013, 07:56 AM
Fotis1991 Re: Fill down into merged... 11-04-2013, 08:04 AM
martindwilson Re: Fill down into merged... 11-04-2013, 08:08 AM
  1. 11-04-2013, 08:04 AM #8
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Fill down into merged cells without skipping rows

    Apologize.. By bad..

    Let's try this one.

    Formula: copy to clipboard 
    =IF(MOD(ROW();6)=0;INDEX(Projects!$A$4:$A$20;ROW()/6);"")
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Fill formula skipping 7 rows
    By uckycool in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-07-2020, 04:57 AM
  2. [SOLVED] Drag/Fill column while skipping multiple reference rows in another worksheet
    By chandlerrw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2013, 07:59 PM
  3. Fill down a column using right(), skipping rows, VBA
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2012, 04:30 PM
  4. Drag-fill skipping a lot of rows
    By PowerSchoolDude in forum Excel General
    Replies: 2
    Last Post: 08-28-2009, 05:50 PM
  5. Fill down into merged cells without skipping rows
    By jamesozzie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2007, 10:03 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1