Excel Magic Trick 1291

Reverse Lookup Array Formula to Score Myers-Briggs Test

DESCRIPTION

Learn how to Score Myers-Briggs Assessment (Test) in Excel with Two Formulas:
(00:13) Problem Introduction
(01:50) Formula 1: Lookup correct letter for each answer. An array Operation, COLUMN function, SUMPRODUCT function and INDEX Function.
(07:48) Formula 2: Count how many letters each respondent scored. COUNTIFS Function.

WORKBOOKS

Download “Excel Magic Trick 1281-1300.zip” Excel-Magic-Trick-1281-1300.zip – Downloaded 332 times – 4 MB




Be the first to comment

Leave a Reply