Count of distinct values with error
I hope you are doing great!
I have another question regarding formulas.
There are two columns:
"E - Entry Number"
- Important: values in this column can duplicate
This is a helper column checking whether or not there is an error in the row.
I have to calculate count of Distinct Entry Numbers with at least 1 Discrepancy (value "Yes")
I have already calculated distinct count of entry numbers, but I don't know how to end up with desired value.
Do you have any ideas?
Help Article Resources
Check out the Formula Handbook template!