I have a Google sheet containing lots of data, and some of it doesn't respect the data validation rules (and the little red triangle appears). Since I have a lot of data, it's quite a long process to find all occurrences of invalid data. I assumed there would be a "jump to next invalid data" feature or something, but I can't find it. Am I missing anything?
You can use filter view to show only rows containing an error.
On the column you want to check, create a filter, set filter option to "Filter by Condition" > "Custom formula is..." > "
indirect("r"&row()&"c"&column(),FALSE) is just a fancy way of saying "this cell" (sorry, no easier way), and
iserror() check if the value is invalid.
Here is an example