Geek asks and answers

Open view of the office - month and year

I just want to sort this based on a combination of month and year (i.e. based on column A) in ascending order. How to do it in OpenOffice Calc? The sort option per month does not work, because I assume that the year is also added.

Here are some data starting with A1:

Month                    Total
September 2011           27825
September 2010           35801
October 2011             108485
October 2010             22223
November 2011            139222
May 2012                 39319
May 2011                 38226
May 2010                 9671
+3
source share
1 answer

There are various solutions:

  • You can convert the values ​​of column A as dates so that OpenOffice / LibreOffice can sort them accordingly (see Solution 1 below);
  • You can divide the text values ​​into two columns (month and year separately) and sort them first during the year, then during the month (see Solution 2 below).

Solution 1

  • , /;
  • Format → Cells... → Numbers;
  • Date ;

  • Format Code: MMMM YYYY format

  • OK

  • , Edit → Find & Replace... CTRL + H

  • Search for , Replace with - (&); More Options, Regular Expression. Replace all:

    search

  • A1, Data → Sort A ( "" ).

OpenOffice/LibreOffice A (, 01/09/2011 2011). " 2011" - MMMM YYYY. OpenOffice/LibreOffice /.

2

  • col A : B, Insert → Columns;
  • A, Data → Text to Columns...
  • Space , OK;
  • Year B1;
  • A1, Data → Sort; , ; OK ( ), Options → Custom sort order; . OK.
+4

More articles:


All Articles