Rank Questions In A Survey

I am trying to rank questions within a survey with excel calculations and not VBA. The rank would take place for each individual section and would provide the top three right questions and top three wrong questions. The example below explains the ranking.

Brief facts:
Each survey has up to 30 sections.

Each section has up to 150 questions.

Each question has none or no limt of sub-questions.(usually between 1 and 20, weekly changes require this number to change)

The section's number of questions change weekly with updates.

This week section 2 begins with #12, next week begins with #16 because more questions were added to section 1.

There are three possible choices to answer a question (yes, no, or n/a.)

Sub-questions are checkboxes of explanations on why the question could be answered wrong.

Each question may have 0-10 points assigned.

Each sub-question may have 0-10 points assigned.

When a question is answered "no" is when a sub-question may be checked to help explain why.

A question with sub-questions may only be assigned points at the sub-question level. The sub-questions have the points and do not sum up to total the question value.
When a question is answered "no" and a sub-question is checked, the points received are 0 points for that sub-question. Unchecked sub-questions receive the full amount of points.

When a question is answered "yes" all points are received.

The Rank:

The rank would take place for each individual section and would provide the top three right questions and top three wrong questions at the question level. My example below has more than three to help explain further.

Select the highest actual score of question or sub-question. Start with 10 points to 0 points.

When a match is found that becomes the first "correct" question rank. #17 is 1 since 17.1 had an 8 point sub-question.

When there is a tie #14,15,18, the tie breaker is the sum of correct sub-questions added to the question score. #14 = 7 points.

The second sort is the # in ascending order #15 and then 18.

The hardest part of the rank is the flexibility of a changing survey with question/sub-question deletions and additions in each section. ...