Thanks for flagging this

I will do a tie-breaker question for these circumstances.
The issue is how to do a tie-braker? Would appreciate some logical support on this, please.
I am thinking of doing a comparison (this is just needed for the winning category):
reminder: highestPersonCat is the variable which max(the 4 variables to find the highest count) and Achiever, Socialiser, Killer, and Explorer hold the total of how many valid answers each group got.
So let's say Achiever = 8, Socialiser = 7, Killer = 4, Explorer = 5 .. highestPersonCat would be 8 .. then I compare and I get the highest personality to be Achiever. However if both Achiever and Socialiser are 8, and the rest 4 and 5, then I have a problem, since it depends on my IF whether the result would be Achiever or Socialiser, as holch pointed out. So I am thinking of this?
Create a new variable: NeedATieBreaker (Equation Type)
Code:
IF (highestPersonCat ==
(
(Achiever AND Socialiser) , "AS",
IF (highestPersonCat == (Achiever AND Killer) , "AK",
IF (highestPersonCat == (Achiever AND Explorer) , "AE",
IF (highestPersonCat == (Socialiser AND Killer) , "SK",
IF (highestPersonCat == (Socialiser AND Explorer) , "SE",
IF (highestPersonCat == (Killer AND Explorer) , "KE", FALSE))
)
)
)
)
Then create 6 question sets with 2 statements each corresponding to the pairs above, mark them hidden and relevant equation for the pair - for example in our case the question dependent on highestPersonCat = "SA" will be unhidden. Depending on the answer I adjust only the
highestPersonality and
whichDescription not the percentages - since the test relies on pairs of 15. So I'll use the tiebreaker to select the highlighted category. Does that make sense?
Is there a simpler solution, please? Many many thanks!!