Excel Magic Trick 1294

Single Cell "Lookup Adding" w Improper Data Set to Score Myers-Briggs Test

DESCRIPTION

If you do not have a Proper Data Set Lookup Table, but rather a Rectangular Improper Lookup Table, learn how to create a single cell formula to Score Myers-Briggs Assessment (Test). This amazing formula is from Bill Szysz at YouTube. Also learn about how array operations are calculated in Excel when the operation compares a column to column, or row to column. Also see the SUM and TRANSPOSE functions.

WORKBOOKS

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




Be the first to comment

Leave a Reply