Hello all! First time posting. I am trying to create a worksheet that will help me navigate all my different recipes. Forgive me as I do my best to explain this.
My ultimate goal is to find exactly the right recipe based on several factors.
For example, today I want a main dish that is chicken-based and uses stewed tomatoes and fresh basil as ingredients and is ready in less than an hour.
I have a master sheet with all of this information included, but I don't know how to make it easy to use.
I currently have a pivot table set up, which I've attached a picture of here. It's definitely a step in the right direction, but I can't figure out how to make it do everything I want (maybe it's not possible?).
I'm new to pivot tables and am realizing the filter doesn't trickle down. For example, if I clicked "breakfast" under the meal type filter, the filter labeled "base" will still give me options such as "ketchup" and "brownie" when there's no breakfast recipes including these things. Is there a way to fix this?
I have also not found an easy way to be able to find recipes based on ingredients. For example, I feel like baking and on hand I have almond flour, chocolate chips, and eggs, but I don't have sugar. Is there a way I can filter out all recipes that include some or all of those first three ingredients, but not sugar? Am I asking the impossible?
If it's helpful, I consider myself "intermediate" as far as Excel skills go. I have little to no experience writing code. This is Office 365.
I am so grateful for any help!
My ultimate goal is to find exactly the right recipe based on several factors.
For example, today I want a main dish that is chicken-based and uses stewed tomatoes and fresh basil as ingredients and is ready in less than an hour.
I have a master sheet with all of this information included, but I don't know how to make it easy to use.
I currently have a pivot table set up, which I've attached a picture of here. It's definitely a step in the right direction, but I can't figure out how to make it do everything I want (maybe it's not possible?).
I'm new to pivot tables and am realizing the filter doesn't trickle down. For example, if I clicked "breakfast" under the meal type filter, the filter labeled "base" will still give me options such as "ketchup" and "brownie" when there's no breakfast recipes including these things. Is there a way to fix this?
I have also not found an easy way to be able to find recipes based on ingredients. For example, I feel like baking and on hand I have almond flour, chocolate chips, and eggs, but I don't have sugar. Is there a way I can filter out all recipes that include some or all of those first three ingredients, but not sugar? Am I asking the impossible?
If it's helpful, I consider myself "intermediate" as far as Excel skills go. I have little to no experience writing code. This is Office 365.
I am so grateful for any help!