Results 1 to 3 of 3

Repeat Formular Pattern

Threaded View

Pee_Tang Repeat Formular Pattern 09-12-2015, 08:35 PM
quekbc Re: Repeat Formular Pattern 09-12-2015, 09:18 PM
Pee_Tang Re: Repeat Formular Pattern 09-12-2015, 09:58 PM
  1. #1
    Registered User
    Join Date
    09-12-2015
    Location
    New Zealand
    MS-Off Ver
    Office365
    Posts
    2

    Repeat Formular Pattern

    Hi All,

    First off sorry if this is in the wrong area!

    I have been trying for hours now to get this to work and its doing my head in now. I have been all over google trying to get this to work but I just cant seem to get it.

    I have some data on Sheet 2, and I want to display it on Sheet 1. On Sheet 2 the data starts at cell C2 then the next is in I2 then O2 etc (so every 6 cells but starting 3 Cells in.)

    I want to show these cells on Sheet 1 for example B2,C2,D2. I have attached an example. I have tried all kinds of OFFSET, INDEX and other formulas but just cant get it. Any help would be great.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lookup and return rows based on pattern start and pattern end
    By JDI in forum Excel General
    Replies: 18
    Last Post: 11-16-2014, 11:44 PM
  2. Complicated formular. Formular, remove text if available
    By TheTrooper1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2014, 12:39 PM
  3. Repeat pattern
    By Slneilan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 01:16 PM
  4. [SOLVED] Replacing a date formular result with another formular
    By stpeter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-06-2013, 06:27 PM
  5. Excel 2007 : To repeat a particular pattern in excel
    By noufelnbacker in forum Excel General
    Replies: 3
    Last Post: 07-08-2012, 01:05 PM
  6. How to repeat a pattern?
    By creekums in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2008, 12:21 AM
  7. repeat rows pattern through pages
    By juststarter in forum Excel General
    Replies: 2
    Last Post: 03-17-2006, 09:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1