+ Reply to Thread
Results 1 to 2 of 2

Using Index to populate a table, but only specific columns from the original table

  1. #1
    Registered User
    Join Date
    05-14-2016
    Location
    Offshore Scotland
    MS-Off Ver
    2013
    Posts
    1

    Using Index to populate a table, but only specific columns from the original table

    Hello all,

    I've setup a table which conditionally imports data from another table using INDEX to populate the new table. However on the original table there are columns with data which is not required in the second table, but I cannot figure out how to get it so it ignores the superflous columns.

    The formula I'm currently using is:

    {=IFERROR(INDEX(tbl,SMALL(IF((INDEX(tbl,,3,1)=FALSE),ROW(tbl)-MIN(ROW(tbl))+1,""),ROWS(A$16:$A16)),,1),"")}

    Many thanks for looking. My Google/Excel-fu is not strong enough for this problem

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Using Index to populate a table, but only specific columns from the original table

    maybe with a pivot table.

    you post a excel 2003 version and add in your profile you use 2013.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Finding a macro that will populate a table from another table based on a columns values
    By Daril_Ghiroza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2015, 02:26 PM
  2. Macro to populate just one specific table on sheet
    By tmleynek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2015, 12:23 PM
  3. [SOLVED] Using Match, Index and concatate to populate a fixture table.
    By foozbear in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-02-2015, 02:54 AM
  4. Replies: 2
    Last Post: 11-22-2013, 02:52 PM
  5. Re-sort table without affecting original table?
    By jfrog in forum Excel General
    Replies: 1
    Last Post: 01-30-2013, 01:19 PM
  6. Replies: 2
    Last Post: 11-03-2009, 03:30 PM
  7. Creating new table from selective data in original table
    By rasmussk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2009, 09:46 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