•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Data validation drop down not returning all options
Drop down looking at 120,000 rows of a separate worksheet. Auto complete works for many but not all options. The filter option on the worksheet containing the list also falls to return these "problem cells". I've tried using get and transform but still can't get it to work.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#data validation
#drop down
#worksheet
#options
#auto complete