Count distinct values in a column IF values in another column = given criteria
Please extend the COUNTIF/COUNTIFS function with a DISTINCT option to enable counting distinct values in the range column when values in the index column match the given criteria, e.g.
COUNTIFD($B:$B,$A2,$C:$C)
would return the count of distinct values in column C where the values in column $B match the criteria in cell $A2
This should be provided for both Excel online and Desktop
4
votes
Anonymous
shared this idea