Quick Google Sheets formula - $10

$10-30 USD

Cancelled

Posted

over 6 years ago

$10-30 USD

Paid on delivery

Using Google Sheets, I have a sheet named "RawDataAndURL" and a sheet named "Ignorders" In another sheet, I want to query RawDataAndURL!A2:P and show all the content where column D does not match any of the values listed in Ignorders!D1:D22. Here's what I have so far but it is not working, something special needs to be done after the word "contains" and I can't figure it out. =query(RawDataAndURL!A2:P,"select * WHERE not D contains "Ignorders!D1:D22") Note: this must work in Google Sheets as opposed to Excel. Post the correct formula, I'll test it, and if it works I'll award you the project and get you paid immediately.

Excel

Microsoft Access

Word

Project ID: 15291248

About the project

16 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

16 freelancers are bidding on average $16 USD for this job

@emamulbd

Dear sir, I read this job's description and understand that I am perfect for for this job. I have lot of experience in this job. So you hire me for the project. Relevant Skills and Experience Excel, Microsoft Access, Word Proposed Milestones $25 USD - milestones

$10 USD in 1 day

5.0

(66 reviews)

6.1

@renesontiongson

Pleasure to help you. Google spreadsheet is my masterpiece and excel. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel and google spreadsheet automation Proposed Milestones $15 USD - 100% milestone and release upon completion

$15 USD in 1 day

4.8

(71 reviews)

5.5

@anachirilov7

A proposal has not yet been provided

$10 USD in 1 day

5.0

(14 reviews)

4.4

@MThasdheeque

A proposal has not yet been provided

$14 USD in 1 day

5.0

(5 reviews)

2.1

@nickret16

Hi there, you will need my expertise on this excel formulas. I can deliver the job fast and working with the formula. Thank you Relevant Skills and Experience Excel, Proposed Milestones $10 USD - Fast delivery of job..

$10 USD in 1 day

5.0

(4 reviews)

2.0

@mido2794

check with me inbox ........................................................................................................

$10 USD in 1 day

4.9

(3 reviews)

1.7

@vinvibhul

I will finish your work as much as faster without any remarks Stay tuned, I'm still working on this proposal.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@Zonairshah

Hi.I can work on Excel & Google Sheets as i have a relative experience in this field and i can finished the work quickly. Thanks ! Relevant Skills and Experience excel & Google Sheets / 5 years Proposed Milestones $10 USD - 1st milestone $7 USD - 2nd milestone

$10 USD in 1 day

0.0

(0 reviews)

0.0

@syafikahanipro

Hello, my name is Nur Syafikah. I can do this job for you. Relevant Skills and Experience - experience with Word and Excel Proposed Milestones $25 USD - Full project

$25 USD in 1 day