How to Score Myers Briggs Assessment in Excel

by excelisfun · 6 videos

Total watch time

40m 49s

at 1× speed · exactly 40 minutes, 49 seconds at 1×

custom

1×	40m 49s
1.25×	32m 39s
1.5×	27m 13s
1.75×	23m 19s
2×	20m 25s

Average video6m 48s

Longest9m 16s

Shortest4m 4s

Compare Open on YouTube JSON

Plan to finish

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

Videos (6)

40m 49s in total · tick what you've watched

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


1	Excel Magic Trick 1292: Power Query Unpivot into Proper Lookup Table to Score Myers-Briggs Test	7:17	2016-03-17
2	Excel Magic Trick 1297: COUNTIFS & SUMPRODUCT & No Helper Column to Score Myers-Briggs Test	6:38	2016-03-24
3	Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Test	9:16	2016-03-16
4	Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score	6:24	2016-03-18
5	Excel Magic Trick 1294: Single Cell "Lookup Adding" w Improper Data Set to Score Myers-Briggs Test	7:10	2016-03-19
6	Excel Magic Trick 1296: COUNTIFS with OR Criteria & SUMPRODUCT to Score Myers-Briggs Test	4:04	2016-03-20

Embed a badge

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

Markdown

[![Watch time: 40m 49s · 6 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0md5Iam72qF5KFBeNqxWecp.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0md5Iam72qF5KFBeNqxWecp)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0md5Iam72qF5KFBeNqxWecp"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0md5Iam72qF5KFBeNqxWecp.svg" alt="Watch time: 40m 49s · 6 videos" width="202" 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/PLrRPvpgDmw0md5Iam72qF5KFBeNqxWecp returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.