Hi.
I have a Google Sheet file using Filter Function and I can't do the same in Numbers. What I need to do is:
1. In Sheet 1 keep a list of restaurants with address and kind of food.
2. In Sheet 2 have a cell I can put like "Chinese", and it shows all the Chinese restaurantes from Sheet 1.
Is there a way to do that in Numbers? I've tried the "Sort & Filter", but didn't work as I expected.
Many thanks,
Luiz
MacBook, OS X Mavericks (10.9.5)
Hi Luiz,
Here is an approach filtering on an added column. It all happens in one table.
The formula in B2 and filled down is:
=IF(C2=C$1,"show","")
This column can be hidden.
C1 is a popup with a first value of "choose cuisine" then "italian", "chinese" etc.
I think this does what you are after.
quinn
Hi. Thanks for answering.
Take a look in what I have in Google Sheet:
Maybe I'm not using it right, but seems to me if I need to change what I want to see (if Chinese, Italian...) I need to go back in Filter dialog and change the value, can't be dynamic, based in a cell value. Besides that seems to me if I use filter all the rest of my sheet disappears. This Filter Function can be put in any place, so I can do, for example, first 5 lines showing Chinese, the next 5 showing Italian etc.
Hope my screenshots helps.
Thanks.
Hello, Quinn.
Many thanks. Worked perfectly. I add another rule to show everything if the pop-up is in "Choose Cuisine", just to avoid the sheet to start blank. What I did was a formula in the "show" column: =IF(D2=$D$1;"Show";(IF($D$1="Choose cuisine...";"-";""))) and inserted "-" in the filter.
Thanks a lot.
Luiz
Hi Luiz,
I actually went to bed last nite thinking that if it was my table I would not want it blank by default. I was going to suggest the OR() function:
IF(OR(C2=C$1,C$1="choose cuisine"),"show","")
Glad you figured it out.
quinn
Hi Luix,
Never mind the second sheet. Create a filter on the column with the type of cuisine. Text contains "Chinese". bingo.
quinn
Thanks again. Good idea to use OR. Just changed my sheet.
Filter Function in Numbers
