I'm wondering if it is possible to do a count for distinct values that meet a certain criteria on a list that has filters applied to it (only use visible).
I found an array formula to calculate distinct values:
Formula:Please Login or Register to view this content.
Real example:
Formula:Please Login or Register to view this content.
I also found a different array formula that counts only visible cells in a list:
Formula:Please Login or Register to view this content.
I'm looking for a way to combine these such that I get the functionality of the second formula with the [criteria] piece of the first formula. Anybody know if this is possible?
Example use case:
Use Case.png
Bookmarks