Finding unique values

[RodneyC]

On a separate tab, I need a formula that will look in the Data4Adcel tab column D and find out how many unique entries there are where two other criteria are met.

1. Where Data4Adcel!$M:$M,{"*Essential*","*Ultimate*","*Standard*","*Premium*"} note -- This will change to only include one criteria such as "*green*"on other cells.

1. Where the value in Data4AdCel column O is greater than 0 Data4Adcel!$O:$O,">0"

Thanks in advance

 

[mehidy1437]

From ChatGPT; Here's the formula that will count the number of unique entries in Data4Adcel column D that meet the two criteria you specified:

=SUM(IF(FREQUENCY(IF((Data4Adcel!$M:$M={"*Essential*","*Ultimate*","*Standard*","*Premium*"})*(Data4Adcel!$O:$O>0),MATCH(Data4Adcel!$D:$D,Data4Adcel!$D:$D,0)),ROW(Data4Adcel!$D:$D)-ROW(Data4Adcel!$D$1)+1),1))

Note: Replace the criteria "Essential","Ultimate","Standard","Premium" with the single criteria such as "green" in the formula as per your requirement.

 

[RodneyC]

From ChatGPT; Here's the formula that will count the number of unique entries in Data4Adcel column D that meet the two criteria you specified:

=SUM(IF(FREQUENCY(IF((Data4Adcel!$M:$M={"*Essential*","*Ultimate*","*Standard*","*Premium*"})*(Data4Adcel!$O:$O>0),MATCH(Data4Adcel!$D:$D,Data4Adcel!$D:$D,0)),ROW(Data4Adcel!$D:$D)-ROW(Data4Adcel!$D$1)+1),1))

Note: Replace the criteria "Essential","Ultimate","Standard","Premium" with the single criteria such as "green" in the formula as per your requiremThank you for

 

[RodneyC]

Thank you for your help. When I copy/paste your formula into the cell, I get this error: Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated. Any ideas?