![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
I selected Data>Filter>Advanced Filter; however,
I had no idea what to do next. I selected Help button,
which sent my browser to:
which was, again, no help.
How do I fill out the "Advanced Filter" dialog?
-regards,
Larry
Hi again:
I hope in this way you can see better my last e-mail:
At first you have to copy the headers of your table at you side of you
table for example or at the end if it isn't big.
Then you have to add the filter that you need and put bellow of the
header that you want to filter.Then run the wizard : Advanced Filter (Before select the table that you
want to filter) and in options you can select where to put the datas
filtereds.Example:
Province
Sells
Costs
Profits
Alajuela
10
2
8
Puntarenas
20
1
19
Limón
20
4
16
Heredia
10
7
3
San José
20
5
15
Alajuela
10
8
2
Heredia
40
9
31
Puntarenas
50
12
38
Advanced Filter:(Read Filter Criteria From)
Province
Sells
Costs
Profits> 20
Results of Advance data Filtereds:
Province
Sells
Costs
Profits
Heredia
40
9
31
Puntarenas
50
12
38
In this case, we filtered the column Sells to show only Province that
have sells higher than 20
Regards,
Jorge Rodríguez
I'm sorry, ... it looks worst
Jorge Rodríguez
I'm sorry, ... it looks worst
>
> Jorge Rodríguez
>
>> Hi again:
>>
>> I hope in this way you can see better my last e-mail:
>>
>> At first you have to copy the headers of your table at you side of you
Ok. Did that. Those are shown in attached in E2:G2
>>
>>> table for example or at the end if it isn't big.
>>>
>>> Then you have to add the filter that you need and put bellow of the
>>> header that you want to filter.
I'm not sure what this means. When you say "add the filter" I guess
that means under the "select_op" column I should put a comparison
operator such as > or >= or <=. Is that right? But where can I put
the logical operators, AND or OR, that are available with the
Standard Filter?
>>>
>>> Then run the wizard : Advanced Filter (Before select the table that you
>>> want to filter) and in options you can select where to put the datas
>>> filtereds.
Where do I find this wizard : Advanced Filter? I looked under
Wizards; however, there was no mention Advanced Filter among the
Wizards listed
>>>
>>> Example:
>>>
>>> Province
>>> Sells
>>> Costs
>>> Profits
>>> Alajuela
>>> 10
>>> 2
>>> 8
>>> Puntarenas
>>> 20
>>> 1
>>> 19
>>> Limón
>>> 20
>>> 4
>>> 16
>>> Heredia
>>> 10
>>> 7
>>> 3
>>> San José
>>> 20
>>> 5
>>> 15
>>> Alajuela
>>> 10
>>> 8
>>> 2
>>> Heredia
>>> 40
>>> 9
>>> 31
>>> Puntarenas
>>> 50
>>> 12
>>> 38
>>> Advanced Filter:(Read Filter Criteria From)
>>> Province
>>> Sells
>>> Costs
>>> Profits
>>>
>>>> 20
I'm guessing that this is:
> 20
and it's a row underneath the Province column in the filter table?
>>>
>>> Results of Advance data Filtereds:
>>> Province
>>> Sells
>>> Costs
>>> Profits
>>> Heredia
>>> 40
>>> 9
>>> 31
>>> Puntarenas
>>> 50
>>> 12
>>> 38
>>> In this case, we filtered the column Sells to show only Province that
>>> have sells higher than 20
>>
[snip]
>>>
>>>> I selected Data>Filter>Advanced Filter; however,
>>>> I had no idea what to do next. I selected Help button,
>>>> which sent my browser to:
>>>>
>>>> https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter&Language=en-US&System=UNIX&Version=5.1#bm_id3151113
>>>>
>>>> which was, again, no help.
>>>>
>>>> How do I fill out the "Advanced Filter" dialog?
>>>>
>>>> -regards,
>>>> Larry
>>>>
[snip]
OOPS. I should have read:
https://wiki.documentfoundation.org/Netiquette#Avoid_Attachments
The .png file showing this, as well as the actual .odf file,
can be found at these links:
https://www.dropbox.com/s/5uosutupnclnxrg/find_transaction.advanced_filter.png?dl=0
https://www.dropbox.com/s/da11qtifkes1q01/find_transactions.ods?dl=0
Hope this makes things clearer.
[snip]
Googling for "libreoffice advanced filter" lead me to:
https://help.libreoffice.org/Calc/Filter:_Applying_Advanced_Filters
which was *much* more helpful than the help I got from pressing
the help button on the "Advanced Filter" dialog, which, as mentioned
in my OP, sent me here:
OOPS. I see on that page, there's a link to "Applying Filters"
and from there, a link to:
https://help.libreoffice.org/5.1/Calc/Filter:_Applying_Advanced_Filters
I should have persisted in reading the document 
Anyway, apparently there's no way to select a range of check numbers
because the vertical conditions are OR'd together instead of AND'd
together. I've tried using the AND(>=1000,<=1200); however,
that results in 0 selected rows. Is there some other way to get
a check range?
I've uploaded a screen shot to:
https://www.dropbox.com/s/piiuz5z1u7s14ch/find_transactions.advanced_filter.NoVerticalAnd.png?dl=0
-regards,
Larry
Is there some other way to get a check range?
Yes, to 'AND' setup your Advanced filter range like this:
date | check no | check no |
>=1000 | <=1100 |
If you install the LO help there is good explanation and example of using
Advanced Filters.
Is there some other way to get a check range?
Yes, to 'AND' setup your Advanced filter range like this:
date | check no | check no |
> >=1000 | <=1100 |
Ah! Never thought of repeating the column headers.
If you install the LO help there is good explanation and example of using
Advanced Filters.
I do have some help; however, as noted in my OP, pressing the help
button sent my browser to:
Looking further, I did find more help here:
https://help.libreoffice.org/5.1/Calc/Filter:_Applying_Advanced_Filters
but that didn't mention the duplication of column names.
It seems intuitive now.
Thanks.
-regards.
Larry
Hi Bruce and all:
Thank you because I didn't remember that way
Regards,
Jorge Rodríguez