One of the most useful formulas for me was being able to find if a cell contained a value from a list of items, this excellent Excel formula https://exceljet.net/formula/cell-contains-one-of-many-things was exactly what I needed.
The formula: =SUMPRODUCT(–ISNUMBER(SEARCH(things,A1)))>0 also works in Google docs, provided that you created a named range.
Here is the spreadsheet for you to look at:
Feel free to poke around the spreadsheet too!
Important note: I also included an example of where my named range contained a blank cell, don’t do this – if you do this, the entire formula falls apart and you’ll get bad values.
To create a named range in Google docs, simply highlight your cells and click on the Data menu bar and select Named Ranges:
Then name it appropriately:
This post is in addition to my previous post on Distilled and simply provides an online Google Docs version of Google CCTLDs and language codes used by Google.
If you see any errors, please let me know in the comments and I’ll happily credit you with a link 🙂
The sheet URL is here.
The new Google Docs spreadsheets are awesome in so many ways, but you might not have access! Sometimes you’ll get a little pop up on the bottom right hand corner, but I didn’t. I couldn’t access the new sheets if my life depended on it, until I started digging around.
If you don’t have access yet (you’ll know if you do because you’ll see the new Add-on menu in the top menu), this is what you need to do:
Step 1: Open up Drive and click on the gear icon top right and click on settings
Step 2: Click on the Edit Settings tab and then click on Try the new Google Sheets checkbox. Voila.
That should be it. If you were one of the unfortunate ones scratching your head, this should fix it for you.