•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need some assistance easily organizing what is becoming a rather large spreadsheet
Our take
Organizing a growing spreadsheet can be a fun challenge, especially when tracking recipes and their ingredients. Your project has great potential, and with the right techniques, you can simplify your experience in Google Sheets. Imagine clicking on a recipe name in column A and instantly hiding all irrelevant data. This functionality is achievable with filters or conditional formatting. By employing these tools, you can create a more streamlined view, making your cooking adventures even more enjoyable. Let’s explore how to implement this solution effectively!
https://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
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- join content from cells in a column without losing content from the corresponding columns.basically how do i make the highlighted screenshot look like the unhighlighted one but with a function for a spreadsheet with like 170k rows. sorry that this is in sheets. im trying to figure out if what i need is to buy excel basically what i want is to condense duplicative info while listing/joining the different pieces, all controlled for case number. https://preview.redd.it/4rfjrucnjdzg1.png?width=1408&format=png&auto=webp&s=ff424cf0a8553fe30b769986169901c1ca25a3bd https://preview.redd.it/c8mtq58ojdzg1.png?width=1080&format=png&auto=webp&s=21ccbdfd8ae8d41eb2d69368e62163df3737088b submitted by /u/Abi-Ankeney-PMM [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Need better way to organise spreadsheethttps://preview.redd.it/oiuewnp0pstg1.png?width=599&format=png&auto=webp&s=d34be7eaeb702d5ded087538a2292a57b295dd65 I am currently keeping track of visiting football stadiums (often called the 72 or the 92) as you can see on the attached image, the shear amount of anfield visits leads to many duplicate entries and am wondering if anyone has a suggestion on tidying this up, so that anfield appears once, but perhaps links through so that i can see all visits there will also likely be more stadiums in the future that will have multiple duplicates. *several columns to the right cropped off because of personal data. submitted by /u/EpilepticFlshbng [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]
Tagged with
#google sheets#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#big data management in spreadsheets#row zero#big data performance#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#large dataset processing#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions