In Progress

Simple Excel Project

I will be getting excel spreadsheets weekly that contain a column of text cells with a good bit of text in each cell.

What I want to do is search these cells and see if ANY keywords are in that cell. If yes, then can simply provide a value of 1.

If no, then provided a value of zero.

Specifically what I want you to do is the following:

1) Make modifications to an example spreadsheet I will provide.

2) Make it so that when I bring in new data, it is as simple as copying the function to the new cells.

3) The text cells are in column k. I want you to add the Keyword test (1 or 0) in column L

4) I want you to make it so that if I add or delete keywords from the keyword tab, it can automatically adapt.

That is it. Should be really fast for an Excel pro.

Let me know how quickly you can deliver

Skills: Excel

See more: Excel pro, simple excel, i want to do excel, how to add example project, excel project, excel project 2/2, excel function, excel cell, 2011 excel add, text function excel, excel text column, simply data excel, bit project, test simple, modifications excel, excel search keywords, simple text excel, excel test project, getting modifications, excel delete, excel contain, excel search function, column data excel, excel test, column excel

About the Employer:
( 24 reviews ) Tampa, United States

Project ID: #1282021

Awarded to:

agihcam

It is my pleasure to help.

$35 USD in 1 day
(39 Reviews)
5.2

18 freelancers are bidding on average $52 for this job

Teloquence

Hi, This can be done. Check your PM.

$30 USD in 0 days
(190 Reviews)
6.8
binaryromel

##### Excel expert here! Please check PM. #####

$30 USD in 1 day
(62 Reviews)
5.6
psprongs

HI, I have extensive knowledge in data processing using vba. I can start immediately. Please check PMB psprongs

$35 USD in 0 days
(10 Reviews)
4.5
sa007

I think my sample work will give you a better idea to select me without any hesitation....See PMB for my sample work

$30 USD in 2 days
(14 Reviews)
4.4
manishadk

please view PMB for details.

$30 USD in 1 day
(14 Reviews)
4.1
win4t4

Hi I can help you with this. I can make custom excel function that will do that work

$30 USD in 1 day
(1 Review)
1.9
sohelberiwala

Respected Sir, I am interested to do work on this project. I am good at Microsoft Excel. Please, check private message for more details. Thank you.

$30 USD in 1 day
(2 Reviews)
1.6
Hnnghia

Hello, I can do it quickly in some hours. Please send me a sample excel file. I can start it now. Regards

$30 USD in 1 day
(1 Review)
1.0
hemanathancoool

l'm ready for the project.........

$150 USD in 2 days
(0 Reviews)
0.0
velliemina04

Please let me do this job for you. I can deliver it for one whole day. I am very interested to help you. Looking forward to your reply soon.

$30 USD in 0 days
(0 Reviews)
0.0
vedasoln

Ready to start and will provide the file in a day.

$30 USD in 1 day
(0 Reviews)
0.0
Accey

see my pm

$40 USD in 0 days
(0 Reviews)
0.0
richardferrer

hoping to work for you soon!

$30 USD in 1 day
(0 Reviews)
0.0
PAULA2

Please consider me.

$30 USD in 1 day
(0 Reviews)
0.0
mariusa

Hello, i'm interested on this project. Please PM.

$45 USD in 2 days
(0 Reviews)
0.0
TheAmazingJob

Sounds challenging to me and at the same time fun. Shall we start?

$50 USD in 2 days
(0 Reviews)
0.0
technocasp

Hi i am interested in this project i will do this sincerely

$250 USD in 2 days
(0 Reviews)
0.0