Ask Your Question
0

Query a master list to produce another list of specific terms

asked 2019-02-13 22:21:14 +0100

Miletech gravatar image

updated 2019-02-13 22:22:22 +0100

Not the best wording on my question but I've been having great difficulty. I'll present a short scenario to paint the picture.

You ask Dave where the cheapest Burgers are, Dave can list off the top of his head every burger joint in a given area and the prices. He writes them down, but not just "Roy's has burgers" and "BK has burgers" no,

image description

But you could also say, "ok Dave: I need a high quality wrench" and he'd list off manufacturers and his ratings and all that.

Now, I'd create a master list of [Roys][Menu Item][Price][Quality][Sub-Category][Category] containing one row for each product I want Roys to offer. In this query though I asked only for burgers. What if I wanted to know just meals, Roys would pop up again with all the Burgers and whatever they sell that could be a meal, like Calzones or Hot Sandwiches.

I've tried using Index, Vlookup, Hlookup, Match, Find, Search and a dozen others I can't remember the name of, and while I'm sure this is something I can get to work with a combination of formulas I just don't know what that combination is. I'd say I qualify somewhere between beginner and intermediate on the understanding of spreadsheets, and any suggestions to get this work I'd like to fully understand the how behind it, so I don't have to ask in the future. Any help is extraordinarily appreciated!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2019-02-14 01:59:43 +0100

robleyd gravatar image

I think you can achieve what you want with Pivot Tables - see https://help.libreoffice.org/Calc/Cre...

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
0

answered 2019-02-14 08:22:16 +0100

libreofficeUser30872 gravatar image

updated 2019-02-14 08:43:11 +0100

It sounds like you want to filter your data on one or more criteria (i.e., show me burgers, show me burgers and meals).

The attached LO spreadsheet contains an example of AutoFilter and Advanced Filter using your sample data:

C:\fakepath\autofilter01.ods

For a short video (good stuff starts about 23 seconds in) on using Data > Autofilter, see: 12- Libre Office - Calc, Open Office -- Calc, Excel Tutorial -- Freeze, Filter, and Split
(If you have the time the 38 short videos are very good. They are a little old, but still very relevant.)

For more information (helpful images) on the Advanced Filter see this Ask Libreoffice entry.

Last, once you get going, Libreoffice Doc:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-13 22:21:14 +0100

Seen: 27 times

Last updated: Feb 14