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.
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
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
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..
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
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