+ Reply to Thread
Results 1 to 5 of 5

Finding a specific row of a matrix in another matrix

  1. #1
    Registered User
    Join Date
    12-27-2014
    Location
    Kerman
    MS-Off Ver
    2011
    Posts
    3

    Finding a specific row of a matrix in another matrix

    Hi there,
    I actually did lots of things to solve it but the solutions are always failed. I used INDEX and MATCH together to find specific data in a matrix.
    so, this is my problem...

    I have a mixed matrix and an original matrix ( I had a matrix then I mixed the rows and do some calculations and find something let's call it Y)
    now I want to lookup specific rows from my original matrix in mixed matrix, so to know it's Y.

    for example:

    Please Login or Register  to view this content.
    you see B is mixed version of A and Y={3;0;5;2} is the new column. I want to find rows of matrix A in matrix B and then return the new Y.
    my matrices are big and have digits with more than 2 or 3 decimals.

    Thanks for your time!
    Last edited by JBeaucaire; 12-27-2014 at 02:02 PM.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Finding a specific row of a matrix in another matrix

    1 always new column is the right one?
    2 how big matrix A?
    3 file please

  3. #3
    Registered User
    Join Date
    12-27-2014
    Location
    Kerman
    MS-Off Ver
    2011
    Posts
    3

    Re: Finding a specific row of a matrix in another matrix

    Thanks for your reply
    I attached the file.
    the green matrix is the original, the blue is mixed, I want to find the appropriate Yp for the Original matrix from the mixed one.

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Finding a specific row of a matrix in another matrix

    =index($N$2:$N$1927,match(A2&B2&C2&D2&E2,$I$2:$I$1927&$J$2:$J$1927&$K$2:$K$1927&$L$2:$L$1927&$M$2:$M$1927,)) as CSE

  5. #5
    Registered User
    Join Date
    12-27-2014
    Location
    Kerman
    MS-Off Ver
    2011
    Posts
    3

    Re: Finding a specific row of a matrix in another matrix

    Thanks dear tim201110, but ...
    I used this function but the answer is #Value! !

    =INDEX($M$2:$M$1927;MATCH(A2&B2&C2&D2&E2;$H$2:$H$1927&$I$2:$I$1927&$J$2:$J$1927&$K$2:$K$1927&$L$2:$L$1927;0))

+ 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. Replies: 2
    Last Post: 11-05-2014, 03:41 AM
  2. Eigenvector of matrix for nxn matrix of variable size
    By rocketscientist165 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2014, 10:51 AM
  3. Replies: 2
    Last Post: 02-11-2014, 05:05 AM
  4. Using a transition matrix as input to a cummulative matrix
    By Walter12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 04:19 AM
  5. Finding the last occurance of a value in a matrix
    By Ayjay in forum Excel General
    Replies: 1
    Last Post: 07-15-2011, 02:27 AM

Tags for this Thread

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