Google Sheets Macro/Formula/Apps Script

Job ID: 33324246

Budget: $30 – $250 USD

We're looking for a couple scripts for Google Sheets:

1) A formula that checks if a cell contains text from a list in another sheet, and returns true/false.

2) A hotkey macro script that that will automatically remove duplicates in a sheet, based on a specific column.