I’m attempting to count ID entries in column AK, counting repeating entries only once, and only counting entries if the year (column AF) is 2016 and the quarter (column AH) is 1.
What am I doing wrong with the formula below? It’s returning too large a number.
=COUNTA(UNIQUE(FILTER(AK:AK,COUNTIFS(AK:AK,AK:AK,AF,AF,2016,AH:AH,1)=0)))
New contributor
user25139999 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.