+ Reply to Thread
Results 1 to 3 of 3

Sort multimple columns and criteria using formulas only.

  1. #1
    Registered User
    Join Date
    01-17-2014
    Location
    Monterrey, Mexico
    MS-Off Ver
    Microsoft Office Proffesional Plus 2010
    Posts
    2

    Sort multimple columns and criteria using formulas only.

    Hi all, Iīm trying to sort a table based on two values using only formulas, I found a very tidy solution for using single criteria in this post, nice work there!

    I would like to further construct on this solution to encompass two criterias, in the attached file you can see a sample list. Basically I would like to sort first for width (w), and then sort for height (h), I can see thereīs a way to expand/nest the formulas provided on the above thread, I just canīt get my head around it...

    Thanks for your help!

    cheers
    saurjusa
    Attached Files Attached Files
    Last edited by saurjusa; 01-17-2014 at 01:11 PM.

  2. #2
    Registered User
    Join Date
    01-17-2014
    Location
    Monterrey, Mexico
    MS-Off Ver
    Microsoft Office Proffesional Plus 2010
    Posts
    2

    Re: Sort multimple columns and criteria using formulas only.

    I may have solve this using rank.eq.
    For the current example it yields the expected results.
    Hopefully this is valida for the working document. you can see my solution in the attachment...

    cheers,
    saurjusa
    Last edited by saurjusa; 01-17-2014 at 02:26 PM.

  3. #3
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Sort multimple columns and criteria using formulas only.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

    I have done it for you this time.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. [SOLVED] Copy multimple worksheets that contain formulas to one master sheet going down the page
    By Kaz09 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2013, 11:31 AM
  2. [SOLVED] How do I sort columns with IF formulas in them?
    By Kristine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-27-2006, 04:15 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