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

W dniu 2016-01-30 o 10:50, Luuk pisze:
> On 30-01-16 01:12, gordom wrote:
> > 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
>
> What 1024 criteria are not enough to solve your problem?
>
> Can you share (a piece) of your problem? Maybe someone knows a smarter
> way to solve your problem using Calc.

I needed to compare two lists with almost 2000 products and find the 
differences (in other words I wanted to hide all products that can be 
found on both lists).
But the problem is already solved. I've sorted a list (only temporarily) 
that was treated as a reference and used a LOOKUP formula. Then I used 
an ordinary Autofilter.

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