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

Filter Function to Filter large data set to Multiple Users

I am trying to use the “FILTER” function to filter a large dataset that changes each day down to a specific group of users. I am getting stuck when trying to add a second “User” to pull from the data.

My Setup:

one sheet named “Dataset” is the data. It is many columns and I need the whole row for that user to be brought into the results. The column that houses the User ID is column R and has a couple hundred different users.

Covers cells A1:AK11932

Second sheet named “users” is the list of user IDs

Covers cells A1:A12

Third sheet named “results” is where I want the rows of filtered data to pull into.

I have gotten a lot of different errors and can’t seem to nail down how to write the formula so it pulls every row with a user ID from my user list. The formula helper excel offers is not really helping.

submitted by /u/JoeExoticHadAFarm
[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
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#large dataset processing
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#AI formula generation techniques
#Excel compatibility
#row zero
#formula generator
#Excel alternatives
#natural language processing for spreadsheets
#financial modeling with spreadsheets