sort multiple columns

  1. R

    MSORT

    MSORT is a powerful and versatile array sorting solution that allows for sorting all or a subset of the columns (or rows) together or independently as well as having various options for dealing with the unsortables (blanks, logicals, and errors) MSORT takes five parameters, one required and...
    • Rnkhch
    • Thread
    • ignore types sort sort arrays sort by column sort by row sort columns independently sort multiple columns sort multiple rows sort rows independently sort subset of columns or rows
    • Replies: 0
    • Forum: Excel LAMBDA Functions
  2. C

    VBA for sorting all data in active sheet(varies in column and row length)

    Hi, Like the title says, I'm trying to make a VBA to sort "all" my data based on D column(descend). I need a VBA that works on the active sheet regardless of name(always different). Also, the number of columns and rows changes every time I run the report, so I cannot have a specific range...
    • cdalgorta
    • Thread
    • sort multiple columns sorting sorting all sheet vba vba sort
    • Replies: 6
    • Forum: Excel Questions
  3. N

    Quick Sort for 2D Array Multiple Column Sort Ascending Descending and Transposed

    I got tired of searching for a Quick Sort version that would do a 2D array, sort multiple columns, sort by ascending and descending order, and also handle a transposed array so I wrote my own. I thought I'd share. It uses the existing QuickSort sub that is found on the web and adds the above...
    • Natas
    • Thread
    • quick sort quicksort sort 2d array sort array sort multiple columns
    • Replies: 14
    • Forum: Excel Questions
  4. G

    VBA To Sort Rows With Multiple Columns In A Range On Cell Click Or Double Click

    I am using MS Windows Desktop and Excel 2019. After my epic fail with trying the Data Filter/Allow Edit Ranges method for sorting a locked worksheet, I need a VBA code for sorting to copy into 40 like-formatted worksheets within the same workbook. On each worksheet, I would like to sort the...
    • G00DNESS
    • Thread
    • click events macro sort and filter sort multiple columns vba & excel
    • Replies: 7
    • Forum: Excel Questions
  5. P

    Sorting Multiple Columns to Match/Align with Data in Column A

    Scenario: - I have Column A filled with roughly 3000 product IDs. (These are the products I want to update) - I have Column B filled with roughly 45,000 product IDs (These are all of my product IDs, in which the 3000 or so from Column A are in...) - Columns C - AZ have data that is connected...
    • PSLAV
    • Thread
    • excel matching data sort multiple columns sorting sorting data
    • Replies: 5
    • Forum: Excel Questions
  6. V

    VBA/Macro to sort rows by first date in multipe columns?

    I am putting together a spreadsheet to help a friend at work. She will have five columns of potential dates. Sometimes there may be only one date in a row or there could be 3 or 4. I need a macro that will automatically sort the rows, based on the first date in one of the five columns. If...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top