Libre Office

Libre Office is a cross-platform office suite available from libreoffice.org.

Calc

• Ctrl+D: Copy contents and formatting from topmost cells to rest of selected range in Calc.

• Filter Items in a List:

  1. Populate column F with 0 or 1 depending on if the value in on that row of column C is listed in column H.
  2. Define column H as a range called List (Data > Define Range).
  3. Place the following in F2 and use it to populate the rest of column F: =COUNTIF(List,C2)
  4. Sort using column F to group all of the matching data together.

Formulae

• Column C or D is blank: OR(ISBLANK(Sheet1.$C2),ISBLANK(Sheet1.$D2))
• Column C is not blank and column D is not blank: AND(NOT(ISBLANK(Sheet1.$C2)),NOT(ISBLANK(Sheet1.$D2)))