Forum Discussion
Complicated formula to search for certain data
Hi guys, I have a big problem, I'm on internsip and I've gotten a task to develop an excel file which will search the data base and take out the names of companys that stopped making transactions...
Hey, Logaraj Sekar
1. Company name is the number in "Customer" column.
2. Exactly
3. For instance Customer number 1 made transactions in 1 and 3 month but he was inactive in the other months so he should be shown in output
4. Yep
5. Any kind, its about finding out about which clients might be disapointed with our services and for that reason they might stopped dealing with us.
When I resolve this main issue I'll be thinking about how to apply some statistical models to that dat, and how I can divide this non active clients into groups.
Big Thanks for your answer. Kindest regards!
1. Company name is the number in "Customer" column.
2. Exactly
3. For instance Customer number 1 made transactions in 1 and 3 month but he was inactive in the other months so he should be shown in output
4. Yep
5. Any kind, its about finding out about which clients might be disapointed with our services and for that reason they might stopped dealing with us.
When I resolve this main issue I'll be thinking about how to apply some statistical models to that dat, and how I can divide this non active clients into groups.
Big Thanks for your answer. Kindest regards!
Actually, it doesnt have to be resolved in the way i described it. Every way that resolves problem and gives me customers that stopped makin transaction will be appreciated :)
maybe I should try somehow apply a frequency function?