R
Rob
Hello I found an excellent formula to count unique values in a given column
and it even modifies the count when they are filtered. Here's the formula I
am using for this...
=SUM(--(FREQUENCY(IF(SUBTOTAL(3,OFFSET($D$6,ROW($D$6:$D$3000)-ROW($D$6),,1)),MATCH($D$6:$D$3000,$D$6:$D$3000,0),""),IF(SUBTOTAL(3,OFFSET($D$6,ROW($D$6:$D$3000)-ROW($D$6),,1)),MATCH($D$6:$D$3000,$D$6:$D$3000,0),""))>0))
I want to modify this to actually count all non-blanks (even duplicates) BUT
I want to subtract all the entries of "No Data Here" and "Sold Out"
So The formula gives me 1114 Unique entries and it adjusts when filtered.
But I want all 2876 entries minus 27 "No Data Here" and minus 56 "Sold Out"
even when filtered.
Is this possible?
Thanks in advance.
and it even modifies the count when they are filtered. Here's the formula I
am using for this...
=SUM(--(FREQUENCY(IF(SUBTOTAL(3,OFFSET($D$6,ROW($D$6:$D$3000)-ROW($D$6),,1)),MATCH($D$6:$D$3000,$D$6:$D$3000,0),""),IF(SUBTOTAL(3,OFFSET($D$6,ROW($D$6:$D$3000)-ROW($D$6),,1)),MATCH($D$6:$D$3000,$D$6:$D$3000,0),""))>0))
I want to modify this to actually count all non-blanks (even duplicates) BUT
I want to subtract all the entries of "No Data Here" and "Sold Out"
So The formula gives me 1114 Unique entries and it adjusts when filtered.
But I want all 2876 entries minus 27 "No Data Here" and minus 56 "Sold Out"
even when filtered.
Is this possible?
Thanks in advance.