+ Reply to Thread
Results 1 to 2 of 2

Column Step Function??

  1. #1
    Registered User
    Join Date
    12-07-2007
    Posts
    1

    Column Step Function??

    Hello all, how do you write a function to retrieve a cell reference for every, say 4 columns, in one row of data.

    Example: Say I'm studying Coca-Cola Company, and I want to analyze 1st quarter sales (only) for every year over a 50 year period. And, suppose all of my data is displayed in one row and it is organized as follows: 1Q-1950, 2Q-1950, 3Q-1950, 4Q-1950, 1Q-1951, 2Q-1951, 3Q-1951, 4Q-1951, ....., 1Q-1999, 2Q-1999, 3Q-1999, 4Q-1999 [i.e., 200 data points]. In order to do my analysis, I need to copy&paste just the 1Q data in a separate row or column. This is quite laborious to do this manually 50 times.

    My question is: How do I retrieve just the 1Q data points under one slick function that can be dragged to produce the fifty data points I want to analyze.
    Last edited by VBA Noob; 12-07-2007 at 05:50 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    Pick out every quarter

    This could be a start. Change the Offset value to retrieve either Q1,Q2,Q3 or Q4. Copy the formula to the right to include more years. A graph could then be made from the Offset values.

    Hope it can be of use
    Ola Sandström

    I just saw your data was organized row wise and not column wise.
    Either, change the Offset formula to work row wise: =OFFSET($H6;(COLUMN(A:A)-1)*4+$B$3-1;0)
    Or, Copy all your data --> Paste special... --> Select Transpose
    Attached Files Attached Files

+ Reply to Thread

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