CarlP wrote:
CarlP wrote:
I see only three filter criteria layers in the standard filter and
auto-filters. Is there a way to get more?
Thanks,
Carl
Any takers? If I select Menu->Filter->AutoFilter and then Standard from
the autofilter pop-up list (or just select Standard Filter from the Data
menu) I get 3 filter criteria to filter the list with. What if I need
more than three (I have several instances when I need to do this).
For example, what if I need to filter a list based on a date range in a
date column, empty in another field, not empty in a third field, and
greater than some amount in a fourth field? The Standard Filter doesn't
seem to let me enter that many filter criteria.
Thanks,
Carl
It's a restriction of the user interface. Calc can handle up to 8
criteria. Filter types "Standard", "Auto" and "Advanced" are just 3
different methods of defining a filter.
I posted a lenghty description about advanced filters here:
http://www.oooforum.org/forum/viewtopic.phtml?t=40598
I use them often, because you can set up named sets of filter-criteria,
selectable from the list box in the advanced filter dialog.
With appropriate formila and named ranges you can even define calculated
criteria with TopX/LowestY, TopX%/LowestY% TODAY(), and statistical
functions.
Advanced filter with up to 8 criteria allows grouping of conditions like:
(Field1<1 AND Field1>0) OR (Field1>=1 AND Field2=TRUE). I believe, this
is the reason for the restriction of dialog "Standard FIlter". The
dialog would be quite complicated if it allows nested ANDs and ORs.
Autofilter simply uses AND connections.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
