Jun 30 2022 04:26 PM
Need help filtering data in an Excel spreadsheet. I can't seem to get the logic right in my formula. The worksheet includes many rows of data. There is a column of names (Column T) and I need to filter to only include the rows where the names in Column T are also one of the names in Column S. I am trying to filter a larger list down to only those who are also members of the second list. All thoughts welcomed, the simpler the better.
Jun 30 2022 05:08 PM
Jun 30 2022 05:27 PM
Jun 30 2022 06:42 PM - edited Jul 01 2022 06:33 AM
try to limit the ranges and give a default if none found like this:
=FILTER(T1:T100, ISNUMBER(MATCH(T1:T100,S1:S100,0)),"none")
Jul 01 2022 06:19 AM