Excel Formula Number Incrementers / Formulas for Sequential Numbers Video Playlist — 2h 41m total, 25 videos

1×	2h 40m 35s
1.25×	2h 8m 28s
1.5×	1h 47m 3s
1.75×	1h 31m 46s
2×	1h 20m 18s

Plan to finish

About 3 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 3 days. Turn on JavaScript to plan around your week.

Videos (25)

2h 41m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.


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

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Markdown

[![Watch time: 2h 41m · 25 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0matjr9DLpc14DJn2OqNgYj.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0matjr9DLpc14DJn2OqNgYj)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0matjr9DLpc14DJn2OqNgYj"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0matjr9DLpc14DJn2OqNgYj.svg" alt="Watch time: 2h 41m · 25 videos" width="203" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0matjr9DLpc14DJn2OqNgYj returns them as JSON — free, no key. API docs →