I have two sheets, one contains a column that has a list of common errors, the other has a column from a log file that has all the errors.
I need something that will check through all the errors and return a count of lines that do NOT contain any text from the common errors. In other words lines that have unknown errors. Additionally it would be useful to highlight the lines in all the errors to show unrecognized errors in red.
Solved by T. L. in 29 mins