Posts by nicfitz26

Re: Count unique occurances based on multiple conditions in another cells

Thanks to you both!

Re: Count unique occurances based on multiple conditions in another cells

Hi,

Thanks for your replies.

Sorry, I should have been clearer.

I only want to count the Email ID's that do not have duplicate entries, but that also have NULL in columns G and I - in the example, that is 7.

Then I want the total count to appear on another sheet, so rather than putting in a formula into Column K, I want a cell within a summary table on another sheet to just display the total number of records that satisfy all 3 conditions.

Hi,

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!