•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
When will Excel nut up and allow table columns to be used as data validation drop-down lists?
We've been stuck using the two workarounds for ages: the "named range" trick, and the "INDIRECT()" trick. Although the named range trick is a bit more flexible and the INDIRECT() trick seems more intuitive, none are ideal.
I recently used Google Sheets and realized HOLY HELL you can just set the value for a data validation range to a table column!
This made me think back to that "what are the advantages of Google Sheets" thread from the other day and realize, what is Excel waiting for? It obviously can be implemented with no problems, so what gives?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#google sheets
#natural language processing for spreadsheets
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#conversational data analysis
#rows.com
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#financial modeling with spreadsheets
#Excel
#Google Sheets
#data validation