+ Reply to Thread
Results 1 to 6 of 6

Selecting data from every fourth column

  1. 11-06-2013, 03:20 AM #1
    Lassebn
    Lassebn is offline
    Registered User
    Join Date
    05-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    14

    Selecting data from every fourth column

    Hi all

    I have made an example of my problem:


    question.xlsx

    I have made a range with a range with data, but i am only interested in the yellow columns finding their way down to the table below. Is it possible to make an automatic function for the table below, that I can expand over a wider area whenever my data table is augmented?
    My problem arises because i have three columns that i dont want displayed in the lower table but I am not able to give excel this information in a formula!

    Best regards
    Lasse
    Reply With QuoteRegister To Reply
  2. 11-06-2013, 03:28 AM #2
    sathiyamoorthy
    sathiyamoorthy is offline
    Registered User
    Join Date
    07-09-2012
    Location
    India
    MS-Off Ver
    Excel 97/2003/2007/2010
    Posts
    67

    Re: Selecting data from every fourth column

    Hi lassebn,

    please paste it in c13 and drag across

    =hlookup(c$12,$c$2:$r$7,$b13+1,0)

    and please change the values in c12, you have entered 9301 instead of 93001...
    Reply With QuoteRegister To Reply
  3. 11-06-2013, 03:31 AM #3
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Selecting data from every fourth column

    Try this in cell C13:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Drag down and across

    I've take the reference to column Z, but you can extend it as far across as you need

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post
    Reply With QuoteRegister To Reply
  4. 11-06-2013, 03:32 AM #4
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Selecting data from every fourth column

    hi Lasse. in the simplest of case where the rows are sorted accordingly from 1 to 5 in both tables:
    =INDEX($C3:$R3,1+(COLUMNS($C13:C13)-1)*4)

    if they are not, then:
    =INDEX($C$3:$R$7,MATCH($B13,$B$3:$B$7,0),1+(COLUMNS($C13:C13)-1)*4)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."

    Tips & Tutorials I Compiled | How to Get Quick & Good Answers
    Reply With QuoteRegister To Reply
  5. 11-06-2013, 03:56 AM #5
    Lassebn
    Lassebn is offline
    Registered User
    Join Date
    05-13-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Selecting data from every fourth column

    Thank you all.. I can see that this problems has many solutions :-)
    Reply With QuoteRegister To Reply
  6. 11-06-2013, 04:27 AM #6
    Ghozi Alkatiri
    Ghozi Alkatiri is offline
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Selecting data from every fourth column

    first formula
    =INDEX($C$3:$R$7,ROW(1:1),(COLUMNS($A:A)-1)*4+1)
    drag right and down
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Re: compare 3 columns between 2 tables add Sheet-1 fourth column data with YEAR ranges
    By AUS Injection in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-14-2013, 01:36 PM
  2. Clear the contents on for rows 4 through 500 on every fourth column starting with column E
    By bdrendel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2013, 01:27 PM
  3. Excel 2007 : Data from 3 columns into Fourth column
    By EsKay! in forum Excel General
    Replies: 1
    Last Post: 06-23-2011, 09:21 PM
  4. Excel 2007 : compare 3 columns in Sheet-1 with Sheet-2 then add Sheet-1 fourth column data ...
    By LearnerEXL in forum Excel General
    Replies: 5
    Last Post: 09-24-2009, 03:46 AM
  5. Add three columns into fourth Column
    By jmycr in forum Excel General
    Replies: 3
    Last Post: 08-23-2008, 12:16 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