Formula to only count unique cells, no duplicates
is there an =countifs formula that can be used to only count unique cells which would avoid counting duplicate cells in that column?
below i want to count W01-W06 only once for the answer to be 6 instead of counting all the duplicate W01 to =8
Help Article Resources
Check out the Formula Handbook template!