+ Reply to Thread
Results 1 to 2 of 2

Rearrange rows in matrix (excel)

  1. #1
    Registered User
    Join Date
    06-25-2015
    Location
    brazil
    MS-Off Ver
    2011
    Posts
    1

    Rearrange rows in matrix (excel)

    Hi everyone,

    I'm actually struggling with excel in order to perform a certain command.

    I have a very basic matrix consisting of rows and columns. What I'd like to do is to rearrange (changing the location of) the rows in the matrix based on a certain criteria.
    What I'd like to accomplish is: If one value (cell) in an entire row of the matrix is higher than a certain value (a cut-off value) then the entire row should be copy/paste to another location in excel in order to gather all the rows with values higher than the specified value on one side and the rows with values lower than the specified value on the other side. It shouldn't affect the columns, only the rows should be switched.

    Can someone help me with this? Maybe with a function or in VBA?

    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Rearrange rows in matrix (excel)

    Without an excel file I should say a pivot table may work
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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. Rearrange rows based on row name
    By JackBauer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2015, 08:41 AM
  2. Replies: 2
    Last Post: 02-11-2014, 05:05 AM
  3. Rearrange matrix
    By vincent86 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2013, 06:05 AM
  4. How to rearrange rows in Excel
    By benjamings in forum Excel General
    Replies: 2
    Last Post: 06-17-2010, 10:18 AM
  5. [SOLVED] Can I rearrange data entered in rows into colums in Excel?
    By Robin in forum Excel General
    Replies: 1
    Last Post: 01-30-2006, 03:50 PM

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