To find the position (row) of the last file revision in a table, you can use a formula based on several Excel functions: MAX, IF, ISERROR, ROW, and INDEX.
In the example shown, the formula in cell H6 is:
{=MAX(IF(...

To check if a cell contains specific text, you can use the SEARCH function together with the ISNUMBER function. In the generic version, substring is the specific text you are looking for, and text represents text in the...

To count cells that do not contain many different strings, you can use a rather complex formula based on the MMULT function. In the example shown, the formula in F5 is:
{=SUM(1-(MMULT(--(ISNUMBER(SEARCH(TRANSPOSE(...

To highlight cells that contain one of many text strings, you can use a formula based on the functions ISNUMBER and SEARCH, together with the SUMPRODUCT function. In the example shown, the conditional formatting applied...

To test if one of several values exists in a range of cells, you can use a formula based on the SUMPRODUCT function. In the example shown, the formula in cell D5 is:
=SUMPRODUCT(--(rng=B5:D5))>0
where "rng" is the...

To test a cell to see if it contains one of many strings, you can use a formula based on the SEARCH, ISNUMBER and SUMPRODUCT functions. The formula in C5, copied down, is:
=SUMPRODUCT(--ISNUMBER(SEARCH(things,B5)))...

To get the position of the first match that does not contain a specific value, you can use an array formula based on the MATCH, SEARCH, and ISNUMBER functions. In the example shown, the formula in E5 is:
{=MATCH(FALSE...

To sum if cells contain either one text string or another (i.e. contain "cat" or "rat") you can use the SUMPRODUCT function.
Background
When you sum cells with "OR" criteria, you need to be careful not to double count...

To check a cell for one of several things, and return the last match found in the list, you can use a formula based on the LOOKUP and SEARCH functions. In the case of multiple matches found, the formula will return the...

To check a cell for one of several things, and return the first match found in the list, you can use an INDEX / MATCH formula that uses SEARCH or FIND to locate a match. In the example shown, the formula in C5 is:
{=...

To extract all matches based on a partial match, you can use use an array formula based on the INDEX and AGGREGATE functions, with support from ISNUMBER and SEARCH. In the example shown, the formula in G5 is:
=IF(F5...

To filter data to include data based on a "contains specific text" logic, you can use the FILTER function with help from the ISNUMBER function and SEARCH function. In the example shown, the formula in F5 is:
=FILTER(...

To filter data in case-sensitive way, you can use the FILTER function with help together with the EXACT function. In the example shown, the formula in F5 is:
=FILTER(B5:D15,EXACT(B5:B15,"RED"))
Which...

To test a cell for one of many strings, while excluding others, you can use a formula based on the SEARCH, ISNUMBER, and SUMPRODUCT functions. In the example shown the formula in C5 is:
=(SUMPRODUCT(--ISNUMBER(SEARCH(...

If you have a list of things (words, substrings, etc) and want to find out which of these things appear in a cell, you can build a simple table and use a formula based on the SEARCH function.
Setup
Suppose you have a...