Hello,
Looking for a formula (in the green box of attachment) that will give me the distinct number of "customers" in column F where the value in column E matches value in field $A$2.
Let's say there are 200 rows. 50 rows match $A$2 to the corresponding values in column E. Out of those 50 rows there are only a total of 4 distinct customers in column F. The other 46 are duplicates.
I want the query to return the number 4.
Bookmarks