Please Need Help Solving Problem

[ohanish]

Hello Everyone,

Been using this site for a while but I can't find the answer to something I am looking for so I joined up and am hoping the community here can help me out.

I am trying to find out if a customer has come into the store once they have placed a phone call to the company. I want to see if they came into the store 10 days after they place the call.

My first thought was identify the unique customer number in the rows and list the number of times they came in for service, but I realized I am not sure how to find out what type of service they received phone call or in store?

If anyone can help I really need it. I have been at this for 2 days now and I can't find a solution.

 

[anglais428]

You would need to record whether it was 'in store' or 'phone' somewhere in your sheet. You could use the =TODAY() function and take away the date of phone call (create a column for this). That would give you the number of days difference. You could build that into and IF statement that would tell you Yes or No.