TEXTJOIN Function, New Excel 2016 Function, Playlist of Videos — 3h 10m total, 23 videos

1×	3h 9m 51s
1.25×	2h 31m 53s
1.5×	2h 6m 34s
1.75×	1h 48m 29s
2×	1h 34m 56s

Plan to finish

About 4 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 4 days. Turn on JavaScript to plan around your week.

Videos (23)

3h 10m in total · tick what you've watched

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


1	Excel Magic Trick 1281: TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items)	10:54	2016-02-20
2	Excel Magic Trick 1282: Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function	5:12	2016-02-23
3	Excel Magic Trick 1295: TEXTJOIN & INDEX Function to create Random Description Codes	3:46	2016-03-21
4	Excel Magic Trick 1300: List All Modes in Single Cell with TEXTJOIN & MODE.MULT	4:21	2016-07-10
5	Excel Magic Trick 1301: Sorted List of Modes in Single Cell with TEXTJOIN Array Formula	7:35	2016-07-11
6	Excel Magic Trick 1302: List Text Modes in Single Cell with TEXTJOIN, HLOOKUP, MATCH & MODE.MULT	6:36	2016-07-13
7	Excel Magic Trick 1304: List Text Modes in Single Cell TEXTJOIN, INDEX, N, IF, MATCH & MODE.MULT	6:14	2016-07-15
8	Excel Magic Trick 1308: Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN	2:26	2016-07-21
9	Excel Magic Trick 1309: Extract Unique List and List in Single Cell: TEXTJOIN Array Formula	9:42	2016-07-22
10	Excel Magic Trick 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN.	20:54	2016-08-10
11	Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data	15:51	2016-08-17
12	Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?	18:07	2016-11-30
13	Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & More	18:52	2017-02-09
14	Excel Magic Trick 1399: Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula	3:54	2017-03-29
15	Mr Excel & excelisfun Trick 183: Lookup and Return Multiple Items And Join Them In Single Cell	11:00	2017-05-05
16	Excel Magic Trick 1460: List All Relative Positions in a Single Cell using TEXTJOIN Array Formula	12:24	2017-09-01
17	Excel Magic Trick 1500: Lookup All Products For Supplier & Join in Single Cell TEXTJOIN & IF	5:54	2018-06-01
18	Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866	11:30	2024-09-19
19	Array of Delimiters in TEXTJOIN for the Perfect Join! Excel Magic Trick Short # 76 part 02	0:56	2025-04-18
20	Excel TEXTJOIN Function Trick to Join Text from 2 Columns into 1 Cell! Excel Short Magic Trick 76	1:20	2025-04-12
21	Opposite of TEXTJOIN? It's TEXTSPLIT used to Split Sub-text from Text String. Excel Short 76 Part 3	1:00	2025-04-19
22	Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907	3:40	2025-09-12
23	The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908	7:43	2025-09-16

Embed a badge

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

Markdown

[![Watch time: 3h 10m · 23 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lk4k5Qs_WmIdLAuViJEw8j.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0lk4k5Qs_WmIdLAuViJEw8j)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0lk4k5Qs_WmIdLAuViJEw8j"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lk4k5Qs_WmIdLAuViJEw8j.svg" alt="Watch time: 3h 10m · 23 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/PLrRPvpgDmw0lk4k5Qs_WmIdLAuViJEw8j returns them as JSON — free, no key. API docs →