i am trying to find my highest 36 consecutive months out of 10 years of pay

Is there a reason you are telling us what you are trying to do?

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Yes, I can not figure out how to find the highest 36 constitutive months in a 10 year period.

So, are you asking for our help? It's hard to tell because I don't see a question in either of your posts.

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

I am sorry i do not have a lot of experience on posting questions. Yes I would love some help. How do you find the highest 36 consecutive months of pay in a column of pay over 10 years?

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

askthem 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:

=SUM(A1:A36)

B1 will contain the total salary for months 1 - 36

B1 will contain the total salary for months 2 - 37

etc.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.

Thanks, I am getting there. I am having difficulty with the conditional formatting. I can not find were i can enter the formula. I do appreciate your help.

poolhawg

What version of Excel are you running?

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

I am using version 2007

Conditional Formatting... New Rule

Use a formula to determine which cells to format

Paste the formula in the box below the line:

Format values where this formula is true:

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Thanks for all your input. I did not master the Use Formula Is: =IF(SUM(A1:A36)=MAX(B:B),1,0), but I do think I can now see my highest 36 consecutive.

I really appreciate the help.

poolhawg

Ask Your Question

Weekly Poll