Create an Excel spreadsheet formula
Budget: $30 – $250 USD
Create an Excel spreadsheet formula
We have an excel spreadsheet, that is updated weekly, that we need to have an Excel spreadsheet formula written to do the following:
If any of the following words, or string within a word (not case sensitive):
waste
disposal
garbage
environmental
dumpster
sanitation
refuse
trash
recycling
are found in either of the two columns:
NAME
NAME_DBA
Then put an X in the MATCH column
1. We must be able to edit the word list, the column header names, and the MATCH column name
2. This formula must run within the spreadsheet
Attached is a sample spreadsheet
You have 3 days to complete this project
Compliance Publishing has awarded more than 200 freelancer projects
All funds will be kept in an escrow account
We have an excel spreadsheet, that is updated weekly, that we need to have an Excel spreadsheet formula written to do the following:
If any of the following words, or string within a word (not case sensitive):
waste
disposal
garbage
environmental
dumpster
sanitation
refuse
trash
recycling
are found in either of the two columns:
NAME
NAME_DBA
Then put an X in the MATCH column
1. We must be able to edit the word list, the column header names, and the MATCH column name
2. This formula must run within the spreadsheet
Attached is a sample spreadsheet
You have 3 days to complete this project
Compliance Publishing has awarded more than 200 freelancer projects
All funds will be kept in an escrow account