Results 1 to 6 of 6

drag down rows that match column in different sheet, but skip every 3 cells in column

Threaded View

mbkr29 drag down rows that match... 01-19-2013, 03:54 PM
mrice Re: drag down rows that match... 01-19-2013, 04:15 PM
mbkr29 Re: drag down rows that match... 01-19-2013, 04:20 PM
mbkr29 Re: drag down rows that match... 01-19-2013, 04:23 PM
mrice Re: drag down rows that match... 01-23-2013, 01:23 PM
mbkr29 Re: drag down rows that match... 01-23-2013, 01:43 PM
  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    kansas city
    MS-Off Ver
    Excel 2007
    Posts
    37

    drag down rows that match column in different sheet, but skip every 3 cells in column

    My example is in cell T2. I have it set up where i can drag the formula across that row correctly, but I cannot figure out how to drag it down each column the way i want it. for example i want the formula:
    in t2 to start at cell 'option data' c2
    in t3 to start at cell 'option data' c8
    in t4 to start at cell 'option data' c14

    when i drag down the formula it starts t3 at cell 'option data' c3
    Attached Files Attached Files

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