# Trying to write "2nd highest" score in addition to MaxScore.

• Re: Trying to write &quot;2nd highest&quot; score in addition to MaxScore.

Holy crap! It works! With 8 columns it adds the 1+5,2+6,3+7,4+8 then displays the 2nd largest of first largest, etc!!!!

Since you put some real effort in this is there any way you could spend just a few more minutes and add some comments 're: what does what?

This type of code I'm not so familiar with. Moreso than straight formula code though! lol. Formula code, to me, is along the lines of the two accounting classes I took at University. I could never pull better than a C+. And this coming from someone that scored the 2nd highest Calc Final one semester among a couple thousand students!

• Re: Trying to write &quot;2nd highest&quot; score in addition to MaxScore.

Quote from wittonline;790642

Holy crap! It works! With 8 columns it adds the 1+5,2+6,3+7,4+8 then displays the 2nd largest of first largest, etc!!!!

Thanks for the feedback

Quote

Since you put some real effort in this is there any way you could spend just a few more minutes and add some comments 're: what does what?

I have edited my post with comments.

• Re: Trying to write &quot;2nd highest&quot; score in addition to MaxScore.

Thank you so much!

I don't know if you'll see this but I forgot to consider a scenerio and I'm not sure how to make your code work. Thank you, again, by the way on adding comments! That does help.

Does this change the game or concept completely?

I need to be able to (consider) the code in the calculations and not be dependent on AN, AF, AP, SP in their own columns.

I want to end up with the AVE or TOTAL of each code occurrence...
(0s are not considered)

Here's another example of source data and columns:

Columns AI AJ

82(SP) 53(AN)
112(AN) 24(AF)
125(AF) 9(AN)
139(AN) 0
108(AN) 67(AF)

--------------
Columns AU AV

82(SP) 13(AN)
96(AN) 0
85(AF) 9(AN)
99(AN) 0
67(AN) 27(AF)

--------------
Columns BA BB

100(SP) 0
99(AN) 0
50(SP) 34(AP)
96(AN) 5(AP)
99(AN) 0
--------------

Here's the result or target values:

AN Fullname AF Fullname AP Fullname SP Fullname
33(AN) 0(AF) 0(AP) 88(SP)
102(AN) 24(AF) 0(AP) 0(SP)
9(AN) 105(AF) 34(AP) 50(SP)
111(AN) 0(AF) 5(AP) 0(SP)
91(AN) 47(AF) 0(AP) 0(SP)

• Re: Trying to write &quot;2nd highest&quot; score in addition to MaxScore.

I think your original question has been answered here. You should start a new thread explaining the problem. You can link this thread in the new post, if necessary.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!