+ Reply to Thread
Results 1 to 5 of 5

Pulling data from a repeating cell pattern

  1. #1
    Registered User
    Join Date
    02-13-2012
    Location
    Wisconsin
    MS-Off Ver
    Excel 2007, 2010, 2003
    Posts
    80

    Pulling data from a repeating cell pattern

    Hello, I have a weather graph I am putting together for fun and cannot figure out a way to bring data in for a table based on a consistent data pattern. My high temp averages are in column C along with other annual averages (High (Cell C7), annual avg. (Cell C9), low (Cell C8), precip (Cell C10) etc.) for that year, my data will go back 50 years. I am trying to find a formula that will bring the temp data into another column so I can create a graph of just the high temps or precipitation or any other measure. I have color coded the cells I am looking for.

    Essentially, I am hoping that in column H, I will have a year (2014 for example) and column I will search for a match between column A and H (year), if a match is found, it will bring in data from that year for a specific category (Temp for example). OR, another option would be to to skip the cells and just pull in data from the cell (High temps would be in cell C7, C18, C29, C40 etc.) through a =C7+11 (cell count, not adding to number result) type of formula.

    temp example.xlsx

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Pulling data from a repeating cell pattern

    I think this should do it for you:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    02-13-2012
    Location
    Wisconsin
    MS-Off Ver
    Excel 2007, 2010, 2003
    Posts
    80

    Re: Pulling data from a repeating cell pattern

    Duh, I never even thought of offsets, should have been obvious in retrospect. Thank you so much Glenn

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Pulling data from a repeating cell pattern

    You're welcome!!

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Pulling data from a repeating cell pattern

    ... and thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autofill a pattern or repeating sequence
    By awcwa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2013, 12:04 PM
  2. Repeating sequential pattern
    By Bdown in forum Excel General
    Replies: 3
    Last Post: 06-07-2012, 05:13 PM
  3. Excel 2007 : repeating pattern interlinked among columns
    By Blakespops in forum Excel General
    Replies: 0
    Last Post: 10-30-2011, 07:18 PM
  4. Repeating a 23 cell pattern over a large number of cells
    By chris.veinot in forum Excel General
    Replies: 1
    Last Post: 07-19-2010, 09:25 AM
  5. [SOLVED] repeating a data pattern in excel
    By KelC in forum Excel General
    Replies: 1
    Last Post: 08-01-2005, 04:05 PM

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