I would like to filter a spreadsheet on LibreOffice 3.4.4 Calc, based on values of a second spreadsheet column. How can I do that ?

I would like intersection and, if possible, complement filters. So the result would be only cells that are in the other spreadsheet, or cells in the first that are *not* in the other.