+ Reply to Thread
Results 1 to 2 of 2

Sort multiple ranges based on the same criteria in 2 column

  1. #1
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Sort multiple ranges based on the same criteria in 2 column

    is it posible to sort multiple ranges in a sheet(Eg. C15:AB50, C60:AB120) based on the same criteria in 2 columns(Eg. Column C: A to Z, column X: Smallest to Largest)?
    Can be aplied to the entire workbook?
    Thanks
    Click the * to say thanks.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Sort multiple ranges based on the same criteria in 2 column

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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] Countifs with multiple criteria and ranges within single column?
    By Skiptomylou in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-13-2018, 12:56 PM
  2. [SOLVED] HELP copying multiple ranges per row based on cell criteria using a Loop
    By Jimbo42 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2016, 01:23 PM
  3. [SOLVED] Summing row ranges based on non-sequential column criteria
    By TexasKersh in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-20-2014, 08:21 AM
  4. [SOLVED] Summing multiple ranges based on criteria....
    By Barking_Mad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2014, 06:42 AM
  5. Add up multiple ranges of data based on criteria.
    By wtmh in forum Excel General
    Replies: 5
    Last Post: 12-17-2009, 04:17 AM
  6. MACROS: Sort by multiple criteria - Create tabs based off of criteria
    By svineyard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2009, 10:48 AM
  7. sum the values of a range based upon multiple ranges and criteria
    By LiveIt... in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2006, 04:23 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