6:11
Excel Magic Trick #203: Sequential Numbers in Formulas ROWS function
excelisfun
12:45
Excel Magic Trick 336: Incrementing Numbers In Formulas
6:41
Excel Magic Trick 692: More About Incrementing Numbers In Formulas
6:21
Excel Magic Trick 700: Return Every Other Cell (Cell Reference That Skips Columns) INDEX Function
7:20
Excel Magic Trick 701: Take Table Of Values and Place In Column With Formula
6:06
Excel Magic Trick 991: Formula To Create Sequential Numbers 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, ...
6:30
Excel Magic Trick 1114: Formula For Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 2...
5:49
Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions
6:58
Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods
4:44
Excel Magic Trick 1123: Dynamic Formula To Create A List of Dates For Month
2:49
Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…
2:27
Excel Magic Trick 1187: Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions
7:03
Excel Magic Trick 1425: Convert 2-Way Table to Single Column Table with INDEX & Number Incrementor
7:41
Excel Magic Trick 1473: Sequential Number Incrementor for Just The Middle Number: AA-0009-17
4:23
Excel Formula to Increment Numbers: 1-6, 7-12, 13-18 for Raffle Ticket - Excel Magic Trick 1585
2:30
Dynamic Arrays to Increment 1-6, 7-12, 13-18 - SEQUENCE Array Function… - Excel Magic Trick 1586
5:24
Excel Formula for Text Number Label with Lead Zeroes: 010-030, 030-050, 050-070 - EMT 1612
5:14
Repeat Number Down Column with Excel Formula & Conditional Formatting - Excel Magic Trick 1633
8:49
Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665.
5:10
Append Two Number Columns and Sort. Excel Magic Trick 1682.
13:30
FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693.
5:06
Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722
4:46
Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754
11:09
Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766
