jeudi 20 août 2020

Need to filter responses by grade, taking out the "false" and n/a" responses

I am trying to filter out the responses on so that for column b and l, the only names left are those of the students that meet the criteria, essentially getting rid of the false and na's in the other cells.

Any help would be appreciated. I attached a picture so you can see the formula I used.

Sheets with temp data

Aucun commentaire:

Enregistrer un commentaire