Hi together,
I have a list (colomn) which contains different values, multiple.
Now i use this formula to count the number of different contained values:
{=SUMME(WENN(HÄUFIGKEIT(WENN(LÄNGE(A2:A10)>0;VERGLEICH(A2:A10;A2:A10;0);""); WENN(LÄNGE(A2:A10)>0;VERGLEICH(A2:A10;A2:A10;0);""))>0;1))}
Now I'd like to count the number of different values by filtering the list by another value.
But unfortunately this formula ignores filtering, it counts also the hidden values.
How must I change this formula, that it counts only visible values?
Is there another way to solve this problem?
THX u all for helping me!
Cayenne
Bookmarks