Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have been trying to automate the Myers Briggs Type Indicator and can read
the results based on numerical input. The results, individual cells, look like this example: I Total = 25, E Total = 15 N Total = 25,S Total = 15 T Total = 10, F Total = 30 P Total = 30, J Total = 10 This means that the person has a stye type of: INTP How can I convert the raw numerical data to display the alpha combination. There are 16 possible permutations as follows (Depedent on the high scores). ESTP, ESTJ, ESFP, ESFJ, ENFP, ENFJ, ENTP, ENTJ, ISTJ, ISTP, ISFJ, ISFP, INFJ, INFP, INTJ, INTP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
multiple results display after filter function | Excel Worksheet Functions |