[Solved] Filtering without using the Filter in Tools

Discuss the spreadsheet application

[Solved] Filtering without using the Filter in Tools

Postby Mandy22 » Sat Apr 17, 2021 12:27 pm

Hi! I'm actually not that familiar in using openoffice calc but can anyone help me?

In Column A there are 3 categories: Red, Blue and Green. What I need is to get all the Red ones and the rows with the data. I found a formula =FILTER(A2:C6,ISNUMBER(SEARCH("rd",A2:C6)),"No results") but when I tried this it's not working.

Example:

Code: Select all   Expand viewCollapse view
Column A    Column B   Column C
Red         5          1-156
Blue        6          1-12458
Green       11         1-1358
Blue        6          1-542
Red         4          1-5632
Red         3          1-43201
Last edited by Mandy22 on Sat Apr 17, 2021 2:37 pm, edited 2 times in total.
OpenOffice 4 on Windows 7
Mandy22
 
Posts: 9
Joined: Fri Apr 16, 2021 11:06 am

Re: Filtering without using the Filter in Tools

Postby eeigor » Sat Apr 17, 2021 12:52 pm

Place the cursor in the data range and turn on the autofilter (menu "Data"). Expand the AutoFilter, uncheck all the boxes, and select only the item you want. LO Calc has no FILTER function.

viewtopic.php?f=75&t=38056
Attachments
Снимок экрана от 2021-04-17 13-59-37.png
Снимок экрана от 2021-04-17 13-59-37.png (8.44 KiB) Viewed 351 times
Ubuntu 18.04 LTS • LibreOffice 7.1.3.2 Community
eeigor
 
Posts: 132
Joined: Sun Apr 12, 2020 10:56 pm

Re: Filtering without using the Filter in Tools

Postby Mandy22 » Sat Apr 17, 2021 2:37 pm

Oohhh I see, so i just have to use the existing filter tools of OpenOffice. Got it. Thank you so much!
OpenOffice 4 on Windows 7
Mandy22
 
Posts: 9
Joined: Fri Apr 16, 2021 11:06 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests