Meal planner don't repeat meals that have already been made for the month.

**rose8693** · 04-11-2019, 01:46 PM

As the title says I'm trying to make a meal planner that doesn't repeat recipes that have already been made for the month.
Below is an image of the code and method I'm currently using.
As you can see fish and chips and Stir fry have already been made but they show up in the meal list. I don't want them to.

I know there should be some way to get them not to show. Something along the lines of if date in range already exists display next, while still maintaining the random functionality.

Any help would be appreciated.

Untitled.png

**Melvosh** · 04-11-2019, 02:14 PM

If you could upload an example workbook, it would be helpful. You can upload a file by clicking Go Advanced, then Manage Attachments (scroll down a bit). Click Browse to find your file, then click Open, then click Upload. Finally click Close this window. The file will be attached when you submit your reply.

**rose8693** · 04-11-2019, 02:41 PM

Thanks for the info. I was wondering how ya'll were getting the files in here. Well it's attached now. Have fun

**Melvosh** · 04-11-2019, 04:57 PM

Try this array formula in A14 and drag down. You'll need to enter it using ctrl+shift+enter:

Please Login or Register  to view this content.

**rose8693** · 04-12-2019, 11:01 AM

Works perfect thanks!

**Melvosh** · 04-12-2019, 12:00 PM

You're welcome, happy eating!

Meal planner don't repeat meals that have already been made for the month.

LinkBack

Thread Tools

Rate This Thread

Display

Meal planner don't repeat meals that have already been made for the month.

Re: Meal planner don't repeat meals that have already been made for the month.

Re: Meal planner don't repeat meals that have already been made for the month.

Re: Meal planner don't repeat meals that have already been made for the month.

Re: Meal planner don't repeat meals that have already been made for the month.

Re: Meal planner don't repeat meals that have already been made for the month.

Thread Information

Users Browsing this Thread

Similar Threads

Weekly Meal Planner Template Edits

[SOLVED] Complie a shopping list from meal planner??

[SOLVED] Help Needed with Meal Planner (Excel attached)

Meal Planner - Edit Macro Code

Want to recreate "Monthly Meal Planner" template

Make a rolling schedule that repeat itself when one turn is made.

Excel Planner+ Calendar connected - Formula too long - don't want repeat on same date

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions