Forum Discussion
Solved
Countif Function
Looking to count the number of values in a column without including duplicates (Column N contains values but has a ton of duplicates, and I cannot remove them from the worksheet) The function mus...
Let's say the start date is in Z1 and the end date in Z2.
=COUNTA(UNIQUE(FILTER(N2:N10000, (E2:E10000>=Z1)*(E2:E10000<=Z2)*(T2:T10000="XXX"))))
Adjust the ranges if your data extend below row 10000.
Let's say the start date is in Z1 and the end date in Z2.
=COUNTA(UNIQUE(FILTER(N2:N10000, (E2:E10000>=Z1)*(E2:E10000<=Z2)*(T2:T10000="XXX"))))
Adjust the ranges if your data extend below row 10000.
to do this without the date ranges, could I remove them and leave the rest of the formula as is?