En cours

Excel Text Search In List

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!

Sheridan

Compétences : Traitement de Données, Excel

Voir plus : search list text excel, excel search text list, search list excel, quick text, i.t. job search, c text search, ask search, ask excel, excel text list, excel search list text, excel search list, excel formula, c text processing, b2, quick excel, excel colour, column text, excel text column, sheridan, questions formula, list words, quick job excel, want excel job, excel contain, text search

Concernant l'employeur :
( 34 commentaires ) Grantham, United Kingdom

N° du projet : #1040778

Décerné à :

koolsidz

Please see PMB

35 $ USD en 0 jours
(93 Commentaires)
5.6

21 freelance ont fait une offre moyenne de 43 $ pour ce travail

ShiaFirst

Provide me the excel sheet. i can do it right now.

30 $ USD en 1 jour
(28 Commentaires)
6.3
schandraram

Hello - My bid is for delivery within an hour of VBA code to highlight cells in column B containing any word in C2:C20. Thanks. Chandra

40 $ USD en 0 jours
(45 Commentaires)
6.1
northwolves

Easy job for [url removed, login to view] PMB please.

30 $ USD en 0 jours
(37 Commentaires)
4.7
bluefox4ever

Dear Hiring Manager, I want to do this "Excel Text Search In List" project now, let's start immediately. I have read the job description. Please send me the excel and more details of the job. Regards, Oliver

30 $ USD en 0 jours
(12 Commentaires)
3.8
manishadk

please view PMB for details.

35 $ USD en 1 jour
(11 Commentaires)
3.8
muthumuni

Dear Sir/Madam I an ready here to Start it and Do it with in 2 hours maximum for you. So kindly see the PMB.

30 $ USD en 0 jours
(6 Commentaires)
3.5
sujiumesh

please check the pm

30 $ USD en 1 jour
(7 Commentaires)
3.4
captchabuster

check your pm

30 $ USD en 1 jour
(4 Commentaires)
2.6
drchaz

Gold freelancer UK based; 2:1 BSc hons degree; 10years ms office experience advanced word and excel; audio typing experienced as medical secretary for head of departments. 60 wpm typing speed. Reliable; 10/10 freelance Plus

40 $ USD en 1 jour
(1 Commentaire)
1.6
AlanDHJones

Please see PM

30 $ USD en 1 jour
(1 Commentaire)
1.0
GoutamSarker

Hello There I am interested to do the job. Since I meet all the experiences and skill conditions. I assure you Sir, that, I selected I shall do my work most conscientiously. Thank you G Sarker

100 $ USD en 30 jours
(0 Commentaires)
0.0
rathnakanthi

iam glad to work with you.....

150 $ USD en 15 jours
(0 Commentaires)
0.0
analiza04

I am interested in this job...Thinking that I am capable to do the task.

30 $ USD en 1 jour
(0 Commentaires)
0.0
grishkatz

Look PM, please!

30 $ USD en 1 jour
(0 Commentaires)
0.0
Mekdadul

Like this project just time will be complete

30 $ USD en 2 jours
(0 Commentaires)
0.0
GeorgeMelnic

I guarantee the completion of the project in the time frame [url removed, login to view] I might need additional information.(EG: the file may or may not contain some VBA code, etc...)

80 $ USD en 5 jours
(0 Commentaires)
0.0
uniart

Hello! May I have a look at that table or part of it? VBA can be used successfully. More can be accomplished.

30 $ USD en 1 jour
(0 Commentaires)
0.0
m12000

i can do it for you... just trust me

30 $ USD en 1 jour
(0 Commentaires)
3.6
Suraia

Hello Sir, I can do this. I am very much interested for this job. Thanks. Suraia

30 $ USD en 1 jour
(0 Commentaires)
0.0
trywith

I can do it with in 1 day, and I need some more data with example on XL sheet. Thank You

35 $ USD en 0 jours
(0 Commentaires)
0.0