Excel Text Search In List
This project was awarded to koolsidz for $35 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
I need a formula to do the following;
I have a column of sentences in cells b2:b600000.
I have a list of words in cells c2:c20.
I want a formula to highlight the cells (in colour) in column b that contain the words in column c. The words in column b may be in sentences.
I can't seem to get my head round it although I am sure it will be a very quick job for the right person.
I need this really urgently please.
Any questions just ask!
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online