Solved

if formula to return result of mailing

Posted on 2014-02-10
5
175 Views
Last Modified: 2014-02-10
Hi Expert's excel 2007

I need a formula to track the number of times a customer has been chased.

Col a.       Col b.        Col c.      Result
chase.      1046.       Chase.    Called once
1045.       1045.       Chase.     Calked twice
chase.     Chase.     Chase.    Nevere chased
0
Comment
Question by:route217
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 50

Expert Comment

by:barry houdini
ID: 39847550
Is there only 3 columns? If so try this formula in D2

=CHOOSE(COUNTIF(A2:C2,"Chase")+1,"","Called Twice","Called Once","Never Chased")

regards, barry
0
 

Author Comment

by:route217
ID: 39847602
Hi barry

excellent feedback but getting  called twice when chase chase chase...when answer should be never called.
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 39847653
OK, perhaps you have some leading/trailing spaces - you could use wildcards like this:

=CHOOSE(COUNTIF(A2:C2,"*Chase*")+1,"","Called Twice","Called Once","Never Called")

Is that better?

regards, barry
0
 

Author Comment

by:route217
ID: 39847739
Prefect
0
 

Author Comment

by:route217
ID: 39848001
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question