•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula Shopping List Generator
Our take
Introducing the Formula Shopping List Generator, a powerful tool designed to streamline your meal planning process. By selecting your meal options for the week, you can automate the generation of a consolidated shopping list. While your formula is functioning well, the challenge lies in aggregating the data into a simple, comprehensive list. Instead of using text-to-columns, which separates the formula from its output, consider exploring array functions or unique value aggregations to create a cohesive list that meets your needs effectively.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How do I create dynamic dropdowns that works 2 ways?I have an Order Form sheet set up with a fair bit of code in the background. Part of the Form has order lines with headers of Code, Category and Product Description. I have a separate Products list which I wanted to create the dynamic drop down lists using formulas. I soon found out that you cannot type a FILTER formula directly into the Excel Data Validation source box. After a bit of researching, I figured how to to create dynamic dropdowns by referencing a spill range. The way I've set it up is probably a bit messy (but it works). At the moment the user has to select the category of product they want first. Then the drop down list in Product Description will show only items in that category. When they select the item they want, the drop down list for Code will show the specific code that item relates to. It can work but I was hoping to be able to use partial searches in any of the 3 columns to generate suggestions. eg. Start typing partial item name which would then narrow down options in the drop down list for Products as you type each letter. Select the item and the category and Item Code self populates. Also enable the user to partially type item code or category for a similar result. Hope this makes sense. And if so, any ideas? submitted by /u/AdComplete9707 [link] [comments]
- Looking for advice: uniting grocery shopping listsGreetings excellent people! I used to be a bit more proficient in Excel, nowadays I can use functions but have a little bit of a hard time getting where I want. Case is this: (sorry if some words aren't PC, I'm not a native speaker) I work in a residence where differently challenged and challenging people live and are assisted in their daily lives. I want to create an Excel file where different people write their shopping lists (grocery) and those (like 5) lists are brought together and added up into one list. Now, with a set list of given groceries where people just add in numbers (like eggs: ..., apples: ....,) I do not have a problem. What I want is for people to be able to add their own items, that are then added to the summary list (bonus if similar items are put together). I am already trying stuff and will possibly get back here when I have more specific questions; at this time I'd like to ask for general advice or tips that come to your mind if you hear what I'm trying to do. submitted by /u/roastbrain [link] [comments]
- Generating a random selection of rows based on multiple criteriaI am trying to create a force building tool for a tabletop wargame. I would like it to generate multiple rows of unit info from a table based on certain criteria and have it working for the most part but keep ending up with #SPILL errors. I am sure that there is a much more efficient way of going about this. Here's the overview: https://preview.redd.it/4ghjhqiupksg1.png?width=1256&format=png&auto=webp&s=a6bdc0749397463685bc7f52d8e90f9199fb8d62 The breakdown: A random rom is selected from a table in the worksheet https://preview.redd.it/5telq4v4qksg1.png?width=757&format=png&auto=webp&s=f25aeec460a6b8e5c5750f9d3ff55acaef477658 Then a filter is applied to sort the results according to what is selected in the dropdown menu at B2 https://preview.redd.it/8mt7wxadqksg1.png?width=1236&format=png&auto=webp&s=1e2e6bc4cde488809447de96e1a8d38e8182e8f2 For the most part this method seems to work. The issue is that every few refreshes i get a #SPILL error https://preview.redd.it/ndkvd72nqksg1.png?width=257&format=png&auto=webp&s=57bbb4d9217c9166376c2935a0ce4f85c4b386c0 I have set this formula to run at the bottom of the sheet and ensured there was no data in any cells to the farthest right and down. BONUS: If there is also a way to get this to work and have the random rows be equal to a determined point value. that would be amazing. submitted by /u/simpson95338 [link] [comments]
- Need some assistance easily organizing what is becoming a rather large spreadsheethttps://i.ibb.co/N6kN1bwz/sample.jpg This is an example of a worksheet I am building on Google Sheets. List of recipes I've made and liked in column A, all the ingredients used across them all in row 1 , the amounts of each ingredient that goes into a specific recipe in the cell that corresponds. This is more of a fun project that may be handy for me later, it's not a huge deal if I can't do what I want but it sure would make it easier if I can since this is becoming a pretty big table. What I would like to be able to do is click on a recipe name in column A, and have Excel or Google Sheets hide every cell that does not specify the ingredient needed and the amount needed for that recipe. Is this possible? Ideas how to accomplish this? This submitted by /u/Due-Editor3682 [link] [comments]
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