Build hyperlink with VLOOKUP 
HYPERLINK VLOOKUP 
Calculate a ratio from two numbers 
GCD 
Change negative numbers to positive 
ABS 
Extract unique items from a list 
INDEX MATCH COUNTIF 
Flag first duplicate in a list 
COUNTIF 
Flip table rows to columns 
TRANSPOSE 
Get value of last nonempty cell 
LOOKUP 
Increment a calculation with ROW or COLUMN 
COLUMN ROW 
List contains duplicates 
SUMPRODUCT COUNTIF 
Longest winning streak 
IF FREQUENCY 
Mixed reference for multiplication table 

Pad a number with zeros 
REPT TEXT 
Random date between two dates 
WORKDAY RANDBETWEEN 
Random number between two numbers 
RANDBETWEEN 
Random text values 
CHOOSE RANDBETWEEN 
Randomly assign data to groups 
CHOOSE RANDBETWEEN 
Range contains one of many substrings 
ISNUMBER SUMPRODUCT SEARCH 
Range contains one of many values 
ISNUMBER SUMPRODUCT SEARCH 
Range contains specific text 
COUNTIF 
Range contains specific value 
MATCH COUNTIF 
Reverse a list or range 
INDEX ROW COUNTA 
Transpose table without zeros 
IF TRANSPOSE 