from a list of 12,251 rows and 317 colomns select a list of 78 rows and 317 colomns
Results 1 to 3 of 3

Thread: from a list of 12,251 rows and 317 colomns select a list of 78 rows and 317 colomns
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2014
    Location
    Amsterdam
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default from a list of 12,251 rows and 317 colomns select a list of 78 rows and 317 colomns

    Dear all,

    I have a spread sheet with a list of 12,251 rows and 317 columns. Then I have another list of 78 rows and 2 columns.
    The two lists have the first column in common, as below

    table 1
    heading 1 heading 2 heading 3 heading 4
    1. S 3 jk
    2. D 89 9N
    3. V 34 9HJ
    ..... ... .... ...
    482. K 0 7H
    .... ... .... ...
    2009. BN 54 9
    .... ..... ... ....
    12,251. LO 67 P

    table 2 (total of 78 rows)
    heading 1
    3.
    482.
    2009.
    8220.
    102928.

    I need to create a new table (3) made of the 78 rows of table 2 and the corresponding 317 columns taken from table 1.

    table 3
    heading 1 heading 2 heading 3 heading 4
    3. V 34 9HJ
    482. K 0 7H
    2009. BN 54 9
    102928. LO 67 P

    Thanks for the help!
    Amanda
    Last edited by AmandaSS; Aug 13th, 2019 at 04:14 AM.

  2. #2
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: from a list of 12,251 rows and 317 colomns select a list of 78 rows and 317 colomns

    give it a try

    ABCDEFGHIJK
    1table 1 table 2table 3 
    2heading 1heading 2heading 3heading 4heading 1heading 1heading 2heading 3heading 4
    31S3jk33V349HJ
    42D899N482482K07H
    53V349HJ20092009BN549
    6...............8220102928LO67P
    7482K07H102928
    8..............
    92009BN549
    10................
    11102928LO67P

    Sheet1



    Worksheet Formulas
    CellFormula
    I3=INDEX($A$2:$D$11,MATCH($H3,$A$2:$A$11,0),MATCH(I$2,$A$2:$D$2,0))


  3. #3
    Board Regular
    Join Date
    Jan 2014
    Location
    Amsterdam
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: from a list of 12,251 rows and 317 colomns select a list of 78 rows and 317 colomns

    Thanks AlanY! it works perfectly

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •