Hello All I Need Help On My New Project



Hello Peeps,
I want A Example AIA Or Tutorial On How To filter data between many aspects!
For Example, If I have My Data In Google Spread Sheets (By CloudStich)-Like This And I want To Search All PErsone Who Are

  1. White
    2.Red (Favourite Color) (at least Once In All 4 Column)



the result would be

Samira Wade
Marlene Crossley
Nur Schmitt
Ammar Tomlinson

Kit Barrett Will Not Be include in answers Because although he is White but His Favourite Colore is not Red

All The Four result Will Be show As Card With Full Details All The details Gets Filled In Pre determined Labels
I had worked on this for long and many attempts but never succeed