#### nuked

##### Well-known Member

- Joined
- Mar 20, 2013

- Messages
- 883

Struggling to get my head around an array formula needed to count unique text values in a column, and one further condition in another column (same row).

I could VBA this in a second, but would rather find a formula if possible on this one.

I've found two good options for the unique record count:

{=SUM(IF(FREQUENCY(IF(LEN(Range1)>0,MATCH(Range1,Range1,0),""),IF(LEN(Range1)>0,MATCH(Range1,Range1,0),""))>0,1))}</SPAN>

Or the simpler (and quite brilliant)...</SPAN>

{=SUMPRODUCT((Range<>"")/(COUNTIF(Range,Range&"")))}

I've really struggled adding another condition to either frankly, in the way that I would with:

{=sum(1*(Range=''something")*(Range2="somethingelse"))}

Formulas not my strong point tbh

Any advice appreciated

Thanks

</SPAN>