Monthly Meal Planner

[ShameDonkey]

I am looking to create a two column list from the table titled "Meals" the Range is $C$6:$F$117. Have played with formulas and am coming up dry on a result. Trying to make planning for feeding this infant easier... instead I have created a puzzle.

Would like to get something like this from the table "Meals":

"Meals" Table Clip of top portion again, the full range is $C$6:$F$117 to provide four week worth :

 

[ShameDonkey]

Thank you in advance. I get a lot of ideas and solutions from viewing the threads on this site. You folks are the real MVPs

 

[Eric W]

Welcome to the MrExcel forum!

Try this:

Book4
	C	D	E	F	G	H	I
6	Breakfast	Lunch	Snack	Dinner		Food	Count
7	Oatmeal	Chicken	Yogurt	Chicken		Oatmeal	2
8	Apples	Pear/Spinach/Pea		Sweet Potatoes		Chicken	4
9		Peaches		Pasta/Rice		Yogurt	3
10	Oatmeal	Chicken	Yogurt	Chicken		Apples	2
11	Pears	Broccoli		Carrots		Pear/Spinach/Pea	1
12		Apples		Rice		Sweet Potatoes	1
13						Peaches	2
14	Rice Cereal	Beef	Yogurt	Beef		Pasta/Rice	1
15	Peaches	Sweet Potato		Broccoli		Pears	2
16		Pears		Rice		Broccoli	2
17						Carrots	1
18						Rice	2
19						Rice Cereal	1
20						Beef	2
21						Sweet Potato	1
22
Sheet2

Cell Formulas
Range	Formula
H7:H22	H7	=IFERROR(INDIRECT(TEXT(AGGREGATE(15,3,(ROW($C$7:$F$16)*100+COLUMN($C$7:$F$16))/(COUNTIF($H$6:$H6,$C$7:$F$16)=0)/($C$7:$F$16<>""),1),"R00C00"),0),"")
I7:I22	I7	=IF(H7="","",COUNTIF($C$7:$F$16,H7))

You'd want to try for consistency with the names, you can see that Sweet Potato and Sweet Potatoes come out on different lines. And I assume that Pear/Spinach/Pea means you have a "game-time" decision, so you'll have to figure that out when you shop.

 

[ShameDonkey]

Awesome, adjusted it to meet the table area and rocks it. I will keep that string in mind in the future. Many thanks!

 

[Eric W]

Happy to help!