•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Am I making a common mistake trying to pull a list from another workbook using "Filter"?
I am trying to pull names from another workbook utilizing "Filter." I am starting in workbook1. The lists is in workbook2, but some names are not needed. I am selecting the array in workbook2, then how to filter by saying adjacent data in workbook2 = criteria. For whatever reason, I am getting the typical #Value error. Any common mistake I could be making.
[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
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#Filter
#workbook1
#workbook2
##Value error
#array