1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Adding multiple criteria into filter

Hi, so I am working with a pivot table, and I meed to add like 60 parameters into the drop down filter. They are all same size and data type (product numbers) I am trying to figure out if there is a quicker way than to add them into the field 1 by 1. Perhaps some simple macro or at least something faster than spending 10 mins copying and pasting.

submitted by /u/Solinek69
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#pivot table
#product numbers
#filter
#parameters
#data type