Forum Discussion
Solved
Filtering multiple SSN's
Hi, Is there a way to filter multiple SSN's (at once) on a spreadsheet instead of individually typing the SSN and adding it to the filtered list? EDIT: What I mean by adding to a filtered lis...
mtarler hey! I'm using Excel 365. What I mean by adding to a filtered list is.. I have a spreadsheet of 15,000 employees which includes a column of SSN's. Let's say I have one SSN that I need to locate - I'll filter the spreadsheet for that specific SSN. If I need to then search another SSN but also keep the current SSN that I already filtered - I'll go the SSN column - click the filter drop down - type the SSN - and then check the box "add current selection to filter." That adds the new SSN to the already filtered SSN. So now I have a filtered spreadsheet of two employees from the two SSN's I searched.
My questions is, if I have a list of 60+ SSN's I need to pull from a spreadsheet of 15,000+ employees - is there a simpler way to pull them in bulk rather than individually?
I hope this is a better explanation for you to visualize. Thank you!
My questions is, if I have a list of 60+ SSN's I need to pull from a spreadsheet of 15,000+ employees - is there a simpler way to pull them in bulk rather than individually?
I hope this is a better explanation for you to visualize. Thank you!
syoum So you can use a slicer to make it easier to select the filter items but you would still be clicking them individually. In the attached I give a very basic example of using FILTER to display a filtered version of a table based on a list of values. See attached and hopefully that helps.