without scrolling the entire data set
1 Like
Use the ISERROR function, i.e. add a formula ISERROR($col)
and then you can look for where that formula returns true, e.g. with a column filter or a summary table.