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 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
