Forum Discussion

Copper Contributor

Jan 23, 2025

How can I count unique clients in a each year

Hello all. I am trying to obtain the number of clients that shoped in 2018, 2019, 2020, 2021 and so on. I tryed to use Count(Unique) but it gives me the total number of clients that have shoped in o...

BI & Data Analysis

excel

m_tarler

Bronze Contributor

Jan 23, 2025

try:

=ROWS(UNIQUE(FILTER(columnA, columnB=YEAR)))

Pdrumen

Copper Contributor

Jan 28, 2025

Thank you! I finally did it with COUNT(UNIQUE(FILTER)))