I am trying to count the number of unique entries in a sheet, that also satisfy 2 other conditions.
I've attached an example sheet and the result I need is:
The number of unique values in column E, that also have NULL in column G and NULL in column I.
So, in the example, the result would be 7.
I know I can do this by conditional formatting and filtering, but would prefer a formula, and perhaps also a macro that I could apply as the number of rows in each sheet is up to 20000, and each month's sheet will be a different size.
Any help would be greatly appreciated!