+ Reply to Thread
Results 1 to 2 of 2

Get Maximum value per row of an embedded 2D array to create an embedded 1D column vector

  1. #1
    Registered User
    Join Date
    08-03-2009
    Location
    London, England
    MS-Off Ver
    MS Office 365
    Posts
    13

    Get Maximum value per row of an embedded 2D array to create an embedded 1D column vector

    The problem is to search for a name in matrix, and to return every occurrence per row.
    Please see attachment

    My solution is in error because when a name appears more than once in a row, it appears more than once in the results.
    My solution involves creating an 'embedded' 4x5 matrix and listing it out using SMALL.
    I need to reduce that embedded matrix to a 4x1 vector containing the maximum of each row of the matrix, then use SMALL on that vector.
    Unfortunately, I do not seem to be able to do it, though I can do it on an ordinary (not embedded) matrix using a statement like
    MAX(OFFSET($D$51:$G$54,ROW()-ROW($D$55),0,1,4)).
    I cannot use OFFSET on the embedded matrix.

    Very appreciative of any help from more experienced people!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-03-2009
    Location
    London, England
    MS-Off Ver
    MS Office 365
    Posts
    13

    Re: Get Maximum value per row of an embedded 2D array to create an embedded 1D column vect

    I solved this myself, but I had to introduce another column to sort the original result ignoring blanks and duplicates.
    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)

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