•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula Shopping List Generator
I'm trying to create an automated meal planner and then based on the options I choose for the week to generate a shopping list. Everything is working apart from the fact I can't work out how to actually generate a list which would consolidate the options, aggregate numbers and provide me with a simple list. I've attached a screenshot which shows the formula im using (which is working) But it's then how I use that data to then create the consolidated list. I tried text to columns but that splits out the formula not the actual text that the formula returned.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#generative AI automation
#formula generator