COUNTIFS and Duplicate Values
Hello! I need to figure out a way count the number of records in my issue log, EXCEPT if the records have the same parent number, they can only be counted once.
Is there an easy way to do this? Is there a way to use the DISTINCT formula in the "Parent" column, but also count the blank rows, as long as the Record column isn't blank?
I am open to any suggestion! Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!