Excel - Sort rows by date, when day-month-year is split in columnsCan't insert cells in Excel 2010 -...

PTIJ: Do Irish Jews have "the luck of the Irish"?

Does the attack bonus from a Masterwork weapon stack with the attack bonus from Masterwork ammunition?

Calculate the frequency of characters in a string

PTIJ What is the inyan of the Konami code in Uncle Moishy's song?

Is it true that good novels will automatically sell themselves on Amazon (and so on) and there is no need for one to waste time promoting?

Help rendering a complicated sum/product formula

Can other pieces capture a threatening piece and prevent a checkmate?

How do hiring committees for research positions view getting "scooped"?

Deletion of copy-ctor & copy-assignment - public, private or protected?

Writing in a Christian voice

How to define limit operations in general topological spaces? Are nets able to do this?

What is the relationship between relativity and the Doppler effect?

Pronounciation of the combination "st" in spanish accents

Does .bashrc contain syntax errors?

What does "Four-F." mean?

What favor did Moody owe Dumbledore?

Do I need to consider instance restrictions when showing a language is in P?

Suggestions on how to spend Shaabath (constructively) alone

What are substitutions for coconut in curry?

Do I need to be arrogant to get ahead?

Is honey really a supersaturated solution? Does heating to un-crystalize redissolve it or melt it?

Bash - pair each line of file

Geography in 3D perspective

Why is there so much iron?



Excel - Sort rows by date, when day-month-year is split in columns


Can't insert cells in Excel 2010 - “operation not allowed” error messageExcel's date format without a yearExcel saves a file in .csv but it keeps the columns and the rows as they were in the original sheetHow to “merge” multiple rows in one column while keeping the rest of rows separate? Excel 2010Sorting data in Microsoft Excel when each item spans a variable number of rowsMake Excel insert day and date in a set format on a single click?How do you round a time and date back to a previous day with a formula in excel?Adding missing dates in ExcelExcel - Day and Date of MonthExcel switching year and month for some cells but not others













0















How can I sort the different rows of my data entries per date, when I have the date entered in three different columns: day, month, year?



When I try to custom sort (first month, then day) for the whole document, it tells me that "This operation requires merged cells to be equally sized".



When I try to only select those columns, obviously rest of the columns don't get sorted. Thank you!









share







New contributor




Eva Hidalgo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    How can I sort the different rows of my data entries per date, when I have the date entered in three different columns: day, month, year?



    When I try to custom sort (first month, then day) for the whole document, it tells me that "This operation requires merged cells to be equally sized".



    When I try to only select those columns, obviously rest of the columns don't get sorted. Thank you!









    share







    New contributor




    Eva Hidalgo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      How can I sort the different rows of my data entries per date, when I have the date entered in three different columns: day, month, year?



      When I try to custom sort (first month, then day) for the whole document, it tells me that "This operation requires merged cells to be equally sized".



      When I try to only select those columns, obviously rest of the columns don't get sorted. Thank you!









      share







      New contributor




      Eva Hidalgo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      How can I sort the different rows of my data entries per date, when I have the date entered in three different columns: day, month, year?



      When I try to custom sort (first month, then day) for the whole document, it tells me that "This operation requires merged cells to be equally sized".



      When I try to only select those columns, obviously rest of the columns don't get sorted. Thank you!







      microsoft-excel sorting date





      share







      New contributor




      Eva Hidalgo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      Eva Hidalgo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      Eva Hidalgo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 2 mins ago









      Eva HidalgoEva Hidalgo

      1




      1




      New contributor




      Eva Hidalgo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Eva Hidalgo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Eva Hidalgo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Eva Hidalgo is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1414937%2fexcel-sort-rows-by-date-when-day-month-year-is-split-in-columns%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Eva Hidalgo is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Eva Hidalgo is a new contributor. Be nice, and check out our Code of Conduct.













          Eva Hidalgo is a new contributor. Be nice, and check out our Code of Conduct.












          Eva Hidalgo is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1414937%2fexcel-sort-rows-by-date-when-day-month-year-is-split-in-columns%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...

          Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

          VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...