Forum Discussion
Complicated formula to search for certain data
I just saw your sheet. You want to know the which company stopped transaction.
I need some clarification. Then only i can solve.
1.Company name column not found in excel (if confidential, please specify which column will come as result).
2. For your result, i've to take month and company name but company name not found. Can i take customer column for finding result.
3. Give one manual answer that you have found.
4. In Pivot, 1 to 6 representing months and 1 to 87 representing what company name.
5. Is that for any type of currency or specific currency only.
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?