List the results of a query

Discuss the spreadsheet application

List the results of a query

Postby Marck_97 » Sat Jul 13, 2019 6:37 pm

Hello to everyone,
I want to know if is possible to output the results of a "query" as a list, I will put this immage as example.
Image
Here I want to search for the value "1" in the "B" retangle, When I found it, the sheet must write the target name in the "A" box by writing it in a list.
It is possible ? and if so, how I can do it ?
I ask this because my query will target a lot of values and I need to see all the results in a single page.
Tnx for the attention and cheers!
Marck
Attachments
Cattura x openoffice.PNG
Open office 4.1.6
Marck_97
 
Posts: 5
Joined: Sat Jun 08, 2019 6:40 pm

Re: List the results of a query

Postby FJCC » Sat Jul 13, 2019 7:31 pm

You can do something similar to this simply using the menu Data -> Filter -> Standard Filter. It would be a little simpler if you had column headers in region B, so let's say the two columns are labeled Name and Value. Click on the header Name and select the menu Data -> Filter -> Standard Filter. Set Field Name to Value, Condition to = and Value to 1. Click More Options, click on Copy Results To and choose a target cell. Click OK and the rows with Value = 1 will be transferred to the chosen location.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7195
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: List the results of a query

Postby Marck_97 » Mon Jul 15, 2019 2:29 pm

FJCC wrote:You can do something similar to this simply using the menu Data -> Filter -> Standard Filter. It would be a little simpler if you had column headers in region B, so let's say the two columns are labeled Name and Value. Click on the header Name and select the menu Data -> Filter -> Standard Filter. Set Field Name to Value, Condition to = and Value to 1. Click More Options, click on Copy Results To and choose a target cell. Click OK and the rows with Value = 1 will be transferred to the chosen location.

Tnx for the fast reply sir and sorry if I write back now,
I tried ur method and it works quite well, my only problem is that these "filtering" should be automated.
I mean, each 10 seconds I need to filter out these informations and write them in a list .
there is a way to do this?
Still tnx for the reply between and while waitin for another answer,
I wish u best.
Cheers, Marck
Open office 4.1.6
Marck_97
 
Posts: 5
Joined: Sat Jun 08, 2019 6:40 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot], Marck_97 and 33 guests