if i have this
finalrow = Cells(Rows.Count, "A").End(xlUp).Row
Set myrange = range("c3:c" & finalrow).SpecialCells(xlVisible)
If Application.CountIf(myrange, "Repo") = 0 Then
im basically filtering, one at a time, each name in column A and looking if there are repos in column...