[libreoffice-users] advanced filter to filter out huge amount of not equal data

Hello everyone.
How to filter out data in Calc to exclude huge series of data?
If I want to filter out not equal data now, I use advanced filter. I put 
an operator "<>"in front of criteria data and transpose these criteria 
from rows to columns. What can I do if I have thousands of criteria 
records and there are simply not enough columns in spreadsheet?
Of course I can divided data into several spreadsheets but I want to 
avoid that. Any help will be appreciated.
Regards,

gordom

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted