I would to know the solutions for this problem statements

%3CLINGO-SUB%20id%3D%22lingo-sub-2190554%22%20slang%3D%22en-US%22%3EI%20would%20to%20know%20the%20solutions%20for%20this%20problem%20statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2190554%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EOrderId%20is%20unique%20for%20each%20customer%20and%20they%20have%20a%20chance%20to%20connect%20with%20L1%2FL2%20support%20teams%20to%20get%20their%20issues%20resolved%20in%20online%20shopping.%20I%20have%20an%20excel%20sheet%20which%20has%20the%20following%20data%3A%3C%2FP%3E%3CP%3EOrderID%2C%20incident%2C%20incident%20created%20date%2C%20support%20team(L1%2FL2).%20so%20now%20would%20like%20to%20know%20the%20formulae%20to%20find%20out%20how%20many%20times%20they%20contacted%20L1%20before%20contacting%20L2%20(based%20on%20the%20dates).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20will%20be%20really%20greatful%20if%20u%20someone%20can%20help%20me%20with%20this!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EVoleti%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2190554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,  

OrderId is unique for each customer and they have a chance to connect with L1/L2 support teams to get their issues resolved in online shopping. I have an excel sheet which has the following data:

OrderID, incident, incident created date, support team(L1/L2). so now would like to know the formulae to find out how many times they contacted L1 before contacting L2 (based on the dates).

 

It will be really greatful if u someone can help me with this!!

 

Thanks,

Voleti

1 Reply

@voletilahari257 

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not always in the case of Excel, on the contrary in some cases.

 

* Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)