How do i find text in a sentence in different colomns ?
I have colomn P2 for the formula
I have colomn Q2 until AC2 for the sentences, the sentences are random within these colomn
So I just want to find one word "fixed" within those sentences in colomn Q2 until AC2 and return the word either "fixed" or "not fixed" to colomn P2. If we can't find the word fixed, so we asumed that it's "not fixed".
One way is by countif
One way is countif
=IF(COUNTIF(Q2:AC2,"*fixed*")>0,"FIXED","NOT FIXED")
**you can use also reference cell like COUNTIF(Q2:AC2,"*"&A1&"*") A1 houses the word
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
THANK YOU, WORKS NOW!!!
do you get paid for this ?
Your welcome..
No money involve, this forum is for helping each other.. you can click the button "ADD Reputation" below the names of anyone who helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks