Đang Thực Hiện

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

Kỹ năng: Xử lí dữ liệu, Excel

Xem thêm: search list text excel, excel search text list, search list excel, quick text, ask search, ask excel, excel text list, excel search list text, excel search list, excel formula, 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, column data excel, column excel

Về Bên Thuê:
( 34 nhận xét ) Grantham, United Kingdom

Mã Dự Án: #1040778

Đã trao cho:

koolsidz

Please see PMB

$35 USD trong 0 ngày
(93 Đánh Giá)
5.6

21 freelancer đang chào giá trung bình $43 cho công việc này

ShiaFirst

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

$30 USD trong 1 ngày
(28 Đánh Giá)
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 trong 0 ngày
(45 Đánh Giá)
6.1
northwolves

Easy job for me.See PMB please.

$30 USD trong 0 ngày
(37 Đánh Giá)
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 trong 0 ngày
(12 Đánh Giá)
3.8
manishadk

please view PMB for details.

$35 USD trong 1 ngày
(11 Đánh Giá)
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 trong 0 ngày
(6 Đánh Giá)
3.5
sujiumesh

please check the pm

$30 USD trong 1 ngày
(7 Đánh Giá)
3.4
captchabuster

check your pm

$30 USD trong 1 ngày
(4 Đánh Giá)
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 Thêm

$40 USD trong 1 ngày
(1 Đánh Giá)
1.6
AlanDHJones

Please see PM

$30 USD trong 1 ngày
(1 Đánh Giá)
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 trong 30 ngày
(0 Đánh Giá)
0.0
rathnakanthi

iam glad to work with you.....

$150 USD trong 15 ngày
(0 Đánh Giá)
0.0
analiza04

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

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
grishkatz

Look PM, please!

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
Mekdadul

Like this project just time will be complete

$30 USD trong 2 ngày
(0 Đánh Giá)
0.0
GeorgeMelnic

I guarantee the completion of the project in the time frame provided.Though I might need additional information.(EG: the file may or may not contain some VBA code, etc...)

$80 USD trong 5 ngày
(0 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
0.0
m12000

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

$30 USD trong 1 ngày
(0 Đánh Giá)
3.6
Suraia

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

$30 USD trong 1 ngày
(0 Đánh Giá)
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 trong 0 ngày
(0 Đánh Giá)
0.0