First Problem

[Itaosy]

For k = 3 To UBound(cGrades)
             If LenB(cGrades(k)) Then
                   If grade = cGrades(k) Then
                        cTally(i, k) = cTally(i, k) + 1
                        found = True
                        Exit For
                  End If
             End If
  Next k

I am trying to count the total of my cGrades, working without problem. Then I am trying to limit to only use the top two grades so only add 1 to cTally if top 2, however sometimes the top 2 have 3 or 4 results examples: (1 A*(Geography), 3 A(English, Sciences, History) or (1A*(Ethics), 2 A(Maths, Physics)) etc...
I have tried to use Large function but not successful, should be easy but I may have over complicated it to myself.
How do you approach the problem?

 

[crouchsw]

Please upload an example file... I don't understand your question.

 

[Smallman]

Hi Itasosy

This

should be easy but I may have over complicated it to myself

is a refreshingly honest assessment of your predicament. I would think you have certainly over complicated something. If you upload a file you will get pretty swift assistance. This is good practice when posting to forums as your problem is laid out in the file and if you show the expected results that is all the better.

Take care

Smallman