| 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 non-empty 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 |
