1 min readfrom 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.

https://preview.redd.it/tsteb3sk9tpg1.png?width=1671&format=png&auto=webp&s=bf637182cbd50c8b1f6bba528f5f723ae888a284

submitted by /u/beng934
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#formula generator
#AI formula generation techniques
#Excel alternatives for data analysis
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#automated anomaly detection
#Excel compatibility
#cloud-based spreadsheet applications
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions