Results 1 to 12 of 12

Sorting Columns and keep information in Rows intact

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2009
    Location
    Virginia, US
    MS-Off Ver
    Excel 2003
    Posts
    7

    Sorting Columns and keep information in Rows intact

    I am trying to sort/filter the information by columns but I need the information in each row to stay together for instance...

    1 2 3 4 5
    2 3 4 5 1
    3 4 5 1 2
    4 5 1 2 3
    5 1 2 3 4

    I need to sort the numbers in column 3 in ascending order or filter them but i need the entire row to move when sorted so it needs to look like this


    4 5 1 2 3
    5 1 2 3 4
    1 2 3 4 5
    2 3 4 5 1
    3 4 5 1 2

    I am using the list function to sort and filter the data in the columns but when i try to sort them in ascending order i get....

    1 2 1 4 5
    2 3 2 5 1
    3 4 3 1 2
    4 5 4 2 3
    5 1 5 3 4

    I don't know how to write formulas or VBA's or anything but am willing to try.

    Is it possible to sort the data and get a result like the second set of data? and is there an easy way to make this fool proof so people that use the spreadsheet will not mess up the data?
    Last edited by frstbseallstar10; 05-26-2009 at 12:14 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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