Filtering and Counting Question In Excel

Question

Need help filtering data in an Excel spreadsheet. I can't seem to get the logic right in my formula.&nbsp; 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.

mtarler · Answer

Try=FILTER(T:T, ISNUMBER(MATCH(T:T,S:S,0)))

olliame · Answer

Thanks. I tried your suggestion, and it came back with a #CALC error. Perhaps there is a refinement that might help? I can certainly use the help!

mtarler · Answer

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")

sergeibaklan · Answer

Olliame&nbsp;
Alternatively
=FILTER(T1:T100, COUNTIFS(T1:T100, S1:S100) )

Forum Discussion

Filtering and Counting Question In Excel

4 Replies

Resources