+ Reply to Thread
Results 1 to 4 of 4

sort data based on 2 columns.

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    sort data based on 2 columns.

    I have a small question.

    In sheet1 I have 3 columns with data.

    In the sheet2:
    columnA of sheet1 is in the same place in sheet2
    Column B of sheet1 certain values have been put vertical in row1 of sheet2

    And column C of sheet1 has to sorted based an columnA and row1 in sheet2
    I tried an option that I thought would work.

    Please see attachment.
    Attached Files Attached Files
    Last edited by keis386; 07-31-2012 at 02:56 AM.

  2. #2
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: sort data based on 2 columns.

    Is this what you are trying to do?
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: sort data based on 2 columns.

    Let's see if the attached works for you.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Re: sort data based on 2 columns.

    Thanks a lot both!

+ Reply to Thread

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