How to find errors in a list

How to find errors in a list

by | Jun 7, 2018 | Excel Tips & Tricks

This article shows how to find errors in a list by using ISERROR and MATCH functions in an array formula. Syntax { =MATCH(TRUE, ISERROR(search array), 0) } Steps Start with =MATCH( function Type TRUE, variable to search for the matched values Continue with ISERROR(...