Forum Discussion

Copper Contributor

Jun 30, 2022

Filtering and Counting Question In Excel

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 fil...

excel

Formulas and Functions

mtarler

Silver Contributor

Jul 01, 2022

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

Olliame
Copper Contributor
Jul 01, 2022
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!
- SergeiBaklan
  Diamond Contributor
  Jul 01, 2022
  Olliame
  
  Alternatively
  
  =FILTER(T1:T100, COUNTIFS(T1:T100, S1:S100) )
- mtarler
  Silver Contributor
  Jul 01, 2022
  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")