First time here? Check out the FAQ!
This is a very oldest trick.
Step 1. Convert data of filter to row with condition "not equal" Use formula
=TRANSPOSE("<>"&[Range with filter data])
(Complete the enter a formula by pressing Ctrl+Shift+Enter)
Step 2. Repeat the header of data column in each cell under the string of conditions
Step 3. Apply an advanced filter
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-12 10:01:15 +0200
Seen: 383 times
Last updated: Apr 25