sort by row

  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...
  2. W

    Sort by row, then automatically repeat for each following row.

    I'm sure this is ridiculously simple but I can't figure out how to do it. I have a list of locations in my A column and then each subsequent column has a date I visited that location. Currently, each row is oldest to newest as that is how I have been adding them. I figured out how to sort by...
  3. O

    Sort Columns Titles

    I have a macro who reads CSV files (22 in this test, but they are more) and put data starting on column 9 ("I"). I sort those columns using copy paste transpose, but I don't like this, I'm looking for a better way to sort the titles. My sort code is: Sub SortTitles() Range("I1:AD1").Copy...
  4. B

    Sort Phone Numbers By Rows From Small To Large Or Large To Small

    Hi Friends I Have Phone Numbers Like This To Sort By Rows 66-66970877, 22-34567, 8764576890, 333-7465 (A1,B1,C1,D1) These Are Phone Numbers Which I Have To Short For Small To Large Or Large To Small Sorting Data In Row P1 To S1 22-34567, 333-7465, 66-66970877, 8764576890 (P1,Q1,R1,S1) P1 =...
  5. L

    Preserving data (in alpha order) ACROSS multiple columns

    I did not see a previous Q and A on this, but I am sorry if it has been asked & answered in the past. My problem: I need to sort data across three columns, but preserve the alpha order across the three columns. For example: <tbody> A B C Adam Baker Billy Bob Charles...
  6. B

    How to sort rows by date AND time

    Hello everyone. What I am looking to do is sort the rows in my spreadsheet by date AND time. The cells also contain other data however. For example there is a date 7/23/14 4:45 PM which is then followed by text. Each cell is set up this way. I entered them in ascending order but now I want to...

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