I would like a count of the unique 4-digit characters in Column A where Column B contains initials + date only (excluding instances of initials + date + N/A).
I was using this array formula below which was working well as long as Column B did not have any blanks or cells with "0":
A few days into using the formula, I've realized that there will be cases when there are blanks or cells with "0" in Column B (and Column A for that matter), and the current array formula is including them in its calculation as valid. So instead of a result of 15 instances, the formula is indicating 58 instances.
I have included a sample spreadsheet to illustrate this.
Is there an adjustment that can be made to the formula to ensure that blanks and zeros in either column are not included in the total?