1

I was wondering if anyone out there can help to resolve the issue I am facing right now, actually I wanted to ask that I have 1 column with 5k + rows, and each row has a statement in it and if I search for a keyword , how come I can find out that keyword from the entire column ,and wherever that keyword is occurring, it should mention yes or no or 1 or 0 in front of that row because I can not do it manually for all rows? thanks in anticipation and looking forward to your quick response.

Improve this question

1 Answer 1

Reset to default
1

Use IF and SEARCH together to flag the rows that have "Hi" in them for example. I hope this helps.

=IFERROR(IF(SEARCH("Hi",A1,1)>0,1,0),0)

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

No problem @MuneebHassan , please accept as answer and upvote if helpful.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.