HELP--Text Formulas!

  • Thread starter Thread starter luxe
  • Start date Start date
L

luxe

:confused:

I am DESPERATELY trying to write a text formula that will do the
following:

Let's just say there are 2 columns, A ,B,C,D

I need column A to read YES (or any other differentiating reference) if
any row in Column B contains the word "veritas"

The text in Column B is consisted of extremely long URLs and they are
all different so I can't use a differentiator or numbers of letters to
the right

Is this possible?!?!?!
 
Assuming you want the yes in A in the same row where it found it in B?
in let's say A2 put

=IF(ISNUMBER(SEARCH("veritas",B2)),"YES","")

copy down
 
luxe > said:
Let's just say there are 2 columns, A ,B,C,D
Click to expand...

How about A and B

I need column A to read YES (or any other differentiating reference) if
any row in Column B contains the word "veritas"
Click to expand...

When you say you want *column* A to read "YES" if ANY row in column B, do
you mean you want to duplicate the same formula on each row of that column
(1), or do you mean you want the formula cell at column A in row 2 to show
you whether the corresponding column B contains "veritas" (2)?

It makes more sense to do the latter, but everyone's different.
The text in Column B is consisted of extremely long URLs and they are
all different so I can't use a differentiator or numbers of letters to
the right
Click to expand...
Is this possible?!?!?!
Click to expand...


You can try:
(1) - in A1, put: =IF(COUNTIF(B$1:B$9999,"*veritas*"),"Yes","")

This will read "Yes" when any cell from b1:b9999 contains "veritas", whether
1 says "veritas" or 9500 say "veritas".

(2) in A1, put: =IF(COUNTIF(B1,"*veritas*"),"Yes","")
then copy it down as many rows as you have. this will show you when the data
in column B of whatever row the formula is in (as long as copied so the
reference will change) contains 'veritas'.
 
Back
Top