I have two worksheets. One is a massive list of data (10,000+ entries). A second list contains about 400 entries. Both use a unique six digit number to identify a specific organization (111245 is Organization A, 456789 is Organization B, etc.) and then have similar columns for various data points. I've been scratching my head trying to figure out how to filter the larger dataset, using the unique ID, down to just the organizations in the second data sheet. Short of adding a filter and clicking the 400 individual organizations, is there an easier way to accomplish this?
UPDATE: Included two files as an example. File A is a complete dataset where file B is a smaller subset of the larger dataset. How do I take the organizations from File B to filter File A to show only those organizations. (Again the actual files have 10000+ lines of data that need to be filtered.
Bookmarks