Forum Discussion

Jose_Gonzalez84's avatar
Jose_Gonzalez84
Copper Contributor
Oct 03, 2024

Extract or copy rows of data from one sheet to another based on multiple criteria.

Hello I am not sure which excel function would be best to resolve this. A little background I work in a school setting where students are taking multiple classes and the data given to me is one excel...
excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 03, 2024

Hi Jose_Gonzalez84 

 

You did not mentioned so assumed you run Excel >/= 2021... With RawData and MyStudents ranges formatted as Tables, in sheet MyStudents:

=IF( COUNTA( MyStudents[Name] ),
  FILTER(
    RawData,
    IFNA( XMATCH( RawData[Name], MyStudents[Name] ), 0 )
  ),
  ""
)

 

Resources