sort 2d array

  1. H

    Sort 4 numbers in increasing & decreasing order

    I have a contiguous row of 4 cells D10:G10 which generates +ve numerical values OR 0 (but not null or spaces/(s)). I want to arrange them in: ‘Increasing order’ in 4 contiguous cells M10:P10 (lowest in M10 & highest in P10) ‘Decreasing order’ in 4 contiguous cells R10:U10 (highest in R10 &...
  2. 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
  3. M

    Sort one column in a 2D array

    Hi guys! I have several text files that I imported using excel VBA. I have extracted the needed values and stored them in a 2D array. I'd like to sort a column of the 2D array. Do you have ideas how to go about this? The first column corresponds to the quantity and the second column...

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