Nov 10 2021 06:54 AM - edited Nov 10 2021 08:36 AM
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 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?
Thanks you!
Nov 10 2021 07:13 AM
Nov 10 2021 08:25 AM
Nov 10 2021 12:35 PM
Solution@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.
Nov 10 2021 12:35 PM
Solution@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.