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 |