|re: "I am sorry i do not have a lot of experience on posting questions."|
It's really no different than asking a question face to face. I doubt you would walk up to a co-worker and just blurt out what you want. I assume you would ask them nicely to help you. It should be no different in an on-line forum.
Assuming your "column of pay" is monthly, meaning that you have 120 values, try this:
With your monthly pay in A1:A120, put this formula in B1 and drag it down to B85:
B1 will contain the total salary for months 1 - 36
B1 will contain the total salary for months 2 - 37
The maximum value in B1:B85 will be next to first pay in the highest 36 month period.
To make it easy to spot, select A1:A85 and choose Format...Conditional Formatting.
Use Formula Is: =IF(SUM(A1:A36)=MAX(B:B),1,0)
Choose a Conditional Formatting fill color or font.
The highlighted pay will be the first pay in the highest 36 month period.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.