formula to find if range contains a particular value

  • Thread starter Thread starter nicoll
  • Start date Start date
N

nicoll

I'm trying to come up with a formula to find if range contains a particular
value or text. I'm stuck can anyone help in Excel 2000.

Thanks.
 
I'm trying to come up with a formula to find if range contains a particular
value or text. I'm stuck can anyone help in Excel 2000.

Thanks.
Click to expand...

=COUNTIF(rng,"*" & text & "*")

Value can be a reference or a text string.

If the text string is numeric, then either the values in rng have to be text,
or the quoted asterisks need to be removed.


--ron
 
One way:

=IF(COUNTIF(A1:A100,"particular value or text"), "Particular value
or text found", "Particular value or text not found")
 
Back
Top