sort by date

  1. B

    Sort column chronologically by dates, while also sorting corresponding rows...

    Hi Everyone, Is it possible to sort a column of information by date, while also automatically sorting the corresponding rows next to it? For example, I want to sort the attached image by the dates on the left, but I don't want to have to re-enter the dollar amounts on the right after doing so...
  2. 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...
  3. A

    Trouble with sorting in VBA

    I am trying to finish a macro by sorting a worksheet by the most recent date. The beginning of the macro takes data from one worksheet (ws1) and pastes it to a new worksheet (ws2) along with a time stamp (=IF($B2<>"",IF(A2="",NOW(),A2),"")) in column A. So column A is filled with formulas that...
  4. M

    Sort by date from Text format

    I have a problem when I want to sort text to be a date format although I have already changed to date format. It still sort by text. For demonstrate, I have.. 30/05/2013 31/04/2013 31/05/2013 30/06/2013 it gonna be.. 30/05/2013 30/06/2013 31/04/2013 31/05/2013 As you can see above, It...
  5. S

    Use a formula to sort?

    Hello all, I'm new to this forum have have a question on sorting: I have a table where there are columns with text in the format similar to the following: ="Birthday"&CHAR(10)&TEXT(DATE(2013,3,31),"MM/DD") What I would like to do is to sort this data based on the date part of that function...
  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