Forum Discussion
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) )
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)
)
- This works super for me as long as my last_activity dates are later than the active_since dates, which, logically should be in that order. Thank you!
alpertakci Glad this helped & Thanks for providing feedback
