Forum Discussion
Solved
Determining New Customers
I have a list of customers serving different brands. Please see attached sample data. Each customer may be working with one or multiple brands. I am trying to determine which customers are new. The r...
Assuming I understood, with Excel 2021 or 365:
in K5:
=LET( uCustomers, UNIQUE(Table1[Customer]), FILTER(uCustomers, MINIFS(Table1[Active Since],Table1[Customer],uCustomers) >= EOMONTH(TODAY(),-1)+1) )
alpertakci I would use Power Query for such a task. See if the attached solution works for you.
- Thanks Riny_van_Eekelen! It does work fine, but I am going to go with the formula solution suggested by Lorenzo
