Filter rows by criteria

I need a clean view of active students. Filter the roster to show only rows where Enrollment Status equals Active and Attendance Rate is at least 75 percent; hide the header row from printing and keep the original sheet intact (use a filtered view). I’ll send this filtered view to the dean by Thursday.

Before I hand this filtered list to the dean, make it review-ready: surface a count of filtered rows at the top, highlight any Active students with Attendance Rate below 80 percent in orange, and ensure the filter is a named, shareable view so other teachers can toggle it without changing my sheet. Note any rows excluded because of blank status.

I set the filter to Enrollment Status = Active but the dean says several Active students are missing from the view. I can’t tell if their Status cells contain trailing spaces, different capitalization, or hidden characters. I’m worried the dean will think I’m hiding records. What’s the most likely cause and the fastest way to reveal and fix those mismatches safely?

Every term I recreate filters for different reports and inevitably miss edge cases—extra spaces, inconsistent capitalization, blank cells—so my reports don’t match the SIS. It costs me trust with the dean. What routine or small automation should I adopt so enrollment data is normalized on import and filters work reliably term after term?