Forum Discussion
Finding and selecting values from one dataset in a larger dataset?
Hi, I have a list of about 500 ID numbers in a spreadsheet that I selected from a previous, larger dataset. I now want to go back to the original dataset and find and select these 500 IDs so that...
If you have the most recent version of Excel, I think you would find that the FILTER function would do what you're asking. Or could be used, with appropriate criteria.
Here's a YouTube video that explains that and a couple of other new "dynamic array" functions.
https://www.youtube.com/watch?v=9I9DtFOVPIg