but this depended on the creation of a column externally in Excel that was either "OK" or "Not Found". I am moving the entire workflow to eliminate the need of Excel and would like to take advantage of the is missing values handling.
I am trying:
Add Filter( columns(:Z ), Where(is missing(:Z))),
The Log window says that; Range value cannot be missing.