How to filter by 2 columns, with variable values...

[DanielOrtiz]

Hi everyone, 

With my limited excel formulas knowledge I am stuck. 

I have a table like this:

Student	Parent	Email	Subject	School	Enrollment date
Peter	John Wayne	john.wayne@geemail.com	Maths	Stratus	12/04/2019
John	John Wayne	john.wayne@geemail.com	Science	Stratus	11/09/2017
Diego	Mary Contrary	Mary@contrary.co.au	Music	Stratus	23/05/2018
Vitalii	Mary Contrary	Mary@contrary.co.au	Science	Stratus	23/05/2018
Yulia	Mary Contrary	Mary@contrary.co.au	Maths	Stratus	23/05/2018
Nataliya	Rick Astley	Nevergonna@giveyou.up	Music	School of Rock	8/09/2019
Silvija	Rick Astley	Nevergonna@giveyou.up	English	School of Rock	8/09/2019
Carlos	Elvis Presley	bluesuede@shoes.com	English	Music School	9/02/2019
Ted	Elvis Presley	bluesuede@shoes.com	Maths	Music School	2/04/2018

I would like to filter so I get a final list that would display only the students that would be from the same parent and they ALL will have the same enrollment date:

The final list would be like this one:

Student	Parent	Email	Subject	School	Enrolment date
Diego	Mary Contrary	Mary@contrary.co.au	Music	Stratus	23/05/2018
Vitalii	Mary Contrary	Mary@contrary.co.au	Science	Stratus	23/05/2018
Yulia	Mary Contrary	Mary@contrary.co.au	Maths	Stratus	23/05/2018
Nataliya	Rick Astley	Nevergonna@giveyou.up	Music	School of Rock	8/09/2019
Silvija	Rick Astley	Nevergonna@giveyou.up	English	School of Rock	8/09/2019

Students whose parent is John Wayne or Elvis Presley are no longer in the list because not all of them have the same Enrollment date.

Please help...

Dan

[#2]

Hi @DanielOrtiz 

It's getting late and I couldn't come up with a very smart way to do it in a short time but I've got a solution which should work. See attached file

Hope it helps