[Solved] Advanced Filter, results to new columns

Discuss the spreadsheet application

[Solved] Advanced Filter, results to new columns

Postby Mandy22 » Fri May 07, 2021 11:20 am

Hello! I just want to ask, can you put multiple criterias in one column in advanced filter and the result will show in different columns?

For example in column A there are different colors ( Red, Blue, Green ) i'd like the results in for those in Color Red to be in Column C-E, Color Blue in Column G-I and Color Green in Column K-M.

Is this possible?
Last edited by Mandy22 on Fri May 07, 2021 12:32 pm, edited 1 time in total.
OpenOffice 4 on Windows 7
Mandy22
 
Posts: 9
Joined: Fri Apr 16, 2021 11:06 am

Re: Advanced Filter

Postby eeigor » Fri May 07, 2021 12:03 pm

Each criterion is associated with the name of the corresponding field. You're saying something wrong.
Ubuntu 18.04 LTS • LibreOffice 7.2.2.2 Community
eeigor
 
Posts: 184
Joined: Sun Apr 12, 2020 10:56 pm

Re: Advanced Filter

Postby Mandy22 » Fri May 07, 2021 12:06 pm

eeigor wrote:Each criterion is associated with the name of the corresponding field. You're saying something wrong.


Oh. I'm sorry i thought that's possible. But thank you!
OpenOffice 4 on Windows 7
Mandy22
 
Posts: 9
Joined: Fri Apr 16, 2021 11:06 am

Re: Advanced Filter

Postby eeigor » Fri May 07, 2021 12:17 pm

If you have colors in different columns, you can set the criteria range with the specified color for multiple columns at the same time through "And" (same row) or "Or" (different rows).
Ubuntu 18.04 LTS • LibreOffice 7.2.2.2 Community
eeigor
 
Posts: 184
Joined: Sun Apr 12, 2020 10:56 pm

Re: Advanced Filter

Postby Mandy22 » Fri May 07, 2021 12:32 pm

eeigor wrote:If you have colors in different columns, you can set the criteria range with the specified color for multiple columns at the same time through "And" (same row) or "Or" (different rows).


Ohh okay got it. I appreciate it!
OpenOffice 4 on Windows 7
Mandy22
 
Posts: 9
Joined: Fri Apr 16, 2021 11:06 am

Re: [Solved] Advanced Filter

Postby Villeroy » Fri May 07, 2021 1:17 pm

Advanced filters:
http://forum.openoffice.org/en/forum/do ... hp?id=9938 (select all rows having Date>=F1 AND Date<=F2)
http://forum.openoffice.org/en/forum/do ... p?id=14714 (select all rows having column A=H1 OR B=H1 OR C=H1 OR D=H1 OR E=H1)
Field names (aka column labels) in row #10. The criteria range uses the corresponding field names in row #1. Criteria values in the same row are connected by logical AND as shown in the date example. Criteria values in the different rows are connected by logical OR as shown the other example.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30281
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Advanced Filter

Postby Villeroy » Fri May 07, 2021 2:51 pm

Like the standard filter, the advanced filter has an option to copy the filter result to another place.
Click any cell in the list range.
Call Data>Filter>Advanced...
This selects the whole list range and pops up the adv. filter dialog with the currently active criteria range. If you simply confirm this dialog the criteria will be re-read from the criteria range.
There is an options button which expands the dialog and where you can specify a target cell.
If you specify G10 as target, the filtered result will be copied to the range starting at cell G10.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30281
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: keme and 26 guests