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

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

submitted by /u/Due-Editor3682
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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