Friday, November 25, 2011

How to filter a column in Excel and LibreOffice Calc

If you need, for example, to create a filter that will select all the values from a column that are smaller than 0.05 do the following:

Data > Filter > Standard Filter

Under Field name select the name of your column
Under Condition select <
Enter under Value 0.05

Click More options
Check Copy results to 
Select the field for the results to be copied to
Ok

1 comment:

  1. Short description but understandable! @ all guys: If you have problems with some functions in excel, help yourself with the following website: http://www.excel-aid.com/excel-filter-column-filtering-a-column-using-two-criteria-or-operator.htm It show you step by step how you have to work all of the functions, which maybe have not known.

    ReplyDelete